select count(*) from T1
select count(1) from T1
select count(PK) from T1:confused:
Printable View
select count(*) from T1
select count(1) from T1
select count(PK) from T1:confused:
I think all the three take the same time.
--------------------
suresh
No.
2nd and 3rd will be fast than 1st query.:confused:
But amng 2nd and 3rd which will b fast,i dont know...
All the three will give you same performance. But there will be difference if you are using oracle version 8 or before.
In that case 2nd wil be faster than 1st. and 3rd will be the fastest.