Originally posted by raghud
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 ??
tell us why count(1) would go faster?