Select count(*) will go for full table scan. If it is very huge table it may take more time. Is rewriting SQL with select count(1) is better or ??
|
Results 1 to 9 of 9
Thread: Nested Query in ORACLEThreaded View
|
Click Here to Expand Forum to Full Width |