Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Different query plan sql2000/Express 2005
Message
From
17/05/2007 14:40:15
 
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
01226457
Message ID:
01226495
Views:
28
does ACC_Division in SQL2005 have a clustered index?

>I have the following query:
>
>
>SELECT a.iAvail_id,b.cName
>FROM ACC_Available a
>	LEFT JOIN ACC_Division b 	
>		ON a.cFrom_id = b.cDivision_id 	
>WHERE a.cStatus_id = 'PREV' AND a.iAvail_id = a.iAvailGroup_id
>
>
>Indexes:
>ACC_Available
>- cStatus_id [CLUSTERED]
>- iAvailGroup_id
>- iAvail_id
>ACC_Division
>- cDivision_id [CLUSTERED]
>- cName
>
>When I run it under SQL2000 I get:
>- One Clustered Index Seek for ACC_Available
>- One Clustered Index Seek for ACC_Division
>When I run it under Express 2005 I get:
>- One Clustered Seek for ACC_Available
>- One Index Scan for ACC_Division
>
>ACC_Available has about 190 records on SQL2000 and about 11000 on EXPRESS,
>ACC_Divison has the same amount of records for both SQL2000 and EXPRESS (680).
>
>Why the difference?
>
>Thanks in advance.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform