-
Junior Member
Which will execute fast??
select count(*) from T1
select count(1) from T1
select count(PK) from T1
-
Contributing Member
Re: Which will execute fast??
I think all the three take the same time.
--------------------
suresh
-
Junior Member
Re: Which will execute fast??
No.
2nd and 3rd will be fast than 1st query.
But amng 2nd and 3rd which will b fast,i dont know...
-
Re: Which will execute fast??
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules