Dear AA, thanks ya untuk response nyaa... untuk create index mungkin itu jalan yg ke 100... tuk menghindari impact perfomance ke function laen..
thanks.... On Thu, Jan 22, 2009 at 11:44 AM, aa alidar <[email protected]> wrote: > Sepertinya ndak bisa ya ... > > Kalo query nya lambat, mungkin bisa liat dari execution plannya, kenapa > lambat, apa karena full table scan etc. > SQL>set timing on > SQL>set autotrace on > SQL>SELET * FROM TB_EXAMPLE > > WHERE send_Dt IS NULL; > > Note: Autotrace on perlu full access on table PLAN_TABLE. PLAN_TABLE bisa > dicreated dari utlxplan.sql di rdbms\admin of ORACLE_HOME. > > Kalo di execution plan ada full table scan, coba create index pada SEND_DT. > > Semoga membantu. > > AA > > --- On Thu, 1/22/09, Moch Firman N > <[email protected]<mochfirman%40gmail.com>> > wrote: > > From: Moch Firman N <[email protected] <mochfirman%40gmail.com>> > Subject: [indo-oracle] SQL Tuning : DATE IS NULL ? > To: [email protected] <indo-oracle%40yahoogroups.com> > Date: Thursday, January 22, 2009, 10:18 AM > > > Dear All, > > langsung aja.... > > send_dt --> type : DATE > > SELET * FROM TB_EXAMPLE > WHERE send_Dt IS NULL; > > Apa ada cara laen untuk mengganti where condition di atas.. ? > > thanks and best regards > Piping > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]
