Re: Prepared statement doing table scan
- From: "Abba" <sql_help@xxxxxxx>
- Date: Tue, 13 Oct 2009 15:32:35 +0530
Got it. Thanks Erland!
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns9CA363E05F128Yazorman@xxxxxxxxxxxx
Abba (sql_help@xxxxxxx) writes:
Erland,
Well, it may be possible with a plan guide, but if my suspicion is
correct, it would only make matters worse.
Just curious, how a plan guide would have made things worse here?
The idea was to use a plan guide to force use of the index. But as you
can see from the outcome of thread, the index was not useful because of
the impicit conversion.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Prepared statement doing table scan
- From: Rashmi Dharshan
- Re: Prepared statement doing table scan
- From: Erland Sommarskog
- Re: Prepared statement doing table scan
- From: Rashmi Dharshan
- Re: Prepared statement doing table scan
- From: Erland Sommarskog
- Re: Prepared statement doing table scan
- From: Abba
- Re: Prepared statement doing table scan
- From: Erland Sommarskog
- Prepared statement doing table scan
- Prev by Date: Re: Prepared statement doing table scan
- Next by Date: Re: TempDB
- Previous by thread: Re: Prepared statement doing table scan
- Next by thread: Cannot bulk load because the file
- Index(es):
Relevant Pages
|
