#DateForumTypeThreadPost
306 Aug 2012 @ 05:50 PDTDatabaseReplyNeed tips to fine tune quey which is running for long DDL of the view  Request Text  REPLACE VIEW PVMSUR.GRD_INT_PAID_BMASAP      (        ACCT_I      ...
206 Aug 2012 @ 05:10 PDTDatabaseReplyNeed tips to fine tune quey which is running for long Hi,   The query which is trying to retrive is a view.   It needs 4 TB of spool space to retreive the rows.   So i cant able to give the no of rows presect ...
106 Aug 2012 @ 03:58 PDTDatabaseTopicNeed tips to fine tune quey which is running for long SELECT  ACCT_I ,EVNT_I ,MSUR_NODE_C ,PERD_TYPE_C ,PERD_D ,ACCT_LINK_D ,MSUR_A FROM tablename   The above select query is running for more than 40 minutes. ...