Re: Follow-up :Long running SQL Problem?

2002-04-03 Thread Stephane Faroult
CHAN Chor Ling Catherine (CSC) wrote: Hi Gurus, My senior DBA always tell us that the not in command sucks and we are all encourage to use the select count(*). SQL A is greatly frowned upon and SQL B will be the best. SQL A : SELECT col1,col2 FROM Table_1 WHERE (col1,col2) NOT

RE: Follow-up :Long running SQL Problem?

2002-04-03 Thread CHAN Chor Ling Catherine (CSC)
To: Multiple recipients of list ORACLE-L Subject:Re: Follow-up :Long running SQL Problem? CHAN Chor Ling Catherine (CSC) wrote: Hi Gurus, My senior DBA always tell us