Re: Simple query on huge table uses Index Scan instead of Seek
From: John Hendrikx (hjohn_at_please.remove.this.xs4all.nl)
Date: 04/07/04
- Next message: David Morrison: "Creating index column on query results"
- Previous message: Tim: "stored procs, temp tables, views and recompilations, OH MY!"
- In reply to: Dan Guzman: "Re: Simple query on huge table uses Index Scan instead of Seek"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 07 Apr 2004 17:00:30 +0200
Dan Guzman wrote:
> I ran the script below under SQL 2000 SP3 and the plan showed an index seek.
> I suspect there is something different in your environment. Is the
> collation of the unid column different than the instance or database
> collation?
Yes, this was the problem. After changing the collation on the column
to the one the database was using, the query was correctly optimized.
Thanks for your help!
--John
- Next message: David Morrison: "Creating index column on query results"
- Previous message: Tim: "stored procs, temp tables, views and recompilations, OH MY!"
- In reply to: Dan Guzman: "Re: Simple query on huge table uses Index Scan instead of Seek"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
