Database Tuning (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center