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]> wrote: From: Moch Firman N <[email protected]> Subject: [indo-oracle] SQL Tuning : DATE IS NULL ? To: [email protected] 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]
