used query in paging is very slow , it takes 9 sec to load first page, please need help to solve
Original view in database :
CREATE OR REPLACE FORCE VIEW "UQAMPF"."VI_RR0008_S2" ("TSECLEINT", "TRNCLEINT", "CIECLEINT", "TSENUMDOC", "TSEDSC", "TTCCLEINT", "TTCCOD", "VAETSEORI", "VAETSEORI_DSC", "TSEDATDEB", "EPLCLEINT", "DEMCLEINT", "EPLNUMMAT", "EPLNOMPRN", "ECLCLEINT", "ECLDSCETA", "URGCLEINT", "URGCOD", "URGDSC", "STRCLEINT", "STRCOD", "STRDSC", "LEMDATDEB", "LEMDATFIN", "AFTDSC", "AFTDATDEB", "AFTDATFIN", "TSEFLGPRB", "TPRCLEINT", "TPRCOD", "TPRDSCABR", "TSEDATDEBPRB", "TSEDATFINPRB", "TSECOMPRB", "TSESLDBACCRE", "TRNFLGSTAREF", "TRNFLGSTAFIN", "TRNFLGSTAFER", "TRNFLGSTAANN", "TSEFLGGEN", "UNPCLEINT", "UNPCOD", "UNPDSC", "USRNOMCRE", "DATCRE", "USRNOMMOD", "DATMOD") AS
select tse.tsecleint , -- Clé de la transaction,
tse.trncleint , -- Clé document transactionnel
tse.ciecleint , -- Compagnie de la transaction
tse.tsenumdoc , -- Numéro de la transaction
tse.tsedsc , -- Description de la transaction
ttc.ttccleint , -- Clé du Type de la transaction