> What is the difference between count(*) and count(1)?
You write them differently. One with an asterisk, the other with the digit one. > Which is prefered?
The former as it is the syntax commonly used in SQL literature and guides and manuals. The latter does not provide any performance enhancements on current Oracle versions.
No, you check. Tom suggested you...
" run the count(*) after the count(1) and then ask yourself what effect the file system buffer cache might possibly be having here..."
Have you done that?
Look, Tom Kyte isn't right all the time but it's certainly the way to bet.
As you can see I have restarted the database while executing query each time .Where does the question of system cache arise.It will be fresh.Please clear my doubt.Question of reversing the queries may be opted only if I would have not restarted the database each time.
I think Tom has asked me to reverse the order because I think he had not seen that the I have restarted the database.That SQL I have pasted is quiet big.