-
Select 36 columns versus Count(*) High difference in performance why?
I am selecting 36 columns from two tables
with simple join condition which is taking
more than 30 minutes.
Both tables are indexed.
select column1,column2,column3,.....,column36
from tableA,TableB where tableA.Column1=TableB.column8;
But If I issue the
same above query with count(*) it is coming in less than a second.
select count(*) from
tableA,TableB where tableA.Column1=TableB.column8;
What is the problem here..?
Immediate responses will be highly appriciated..
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
|
Click Here to Expand Forum to Full Width
|