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.