|
Posted by Auday Alwash on 11/28/05 03:59
Further to this:
If I change the first Statement to use an Index Hint it works (index
seek in under a second)!!!! Is something wrong with my SQL Execution
Plan optimizer or something???
declare @find varchar(50)
SET @find = 'TTLD0006423203'
SELECT TOP 250
ConsignmentID,
c.Created
FROM tranzbranch_archive.dbo.tblConsignment c WITH (NOLOCK,INDEX
(ix_tblconsignment))
WHERE c.ConNoteNum LIKE @find + '%'
ORDER BY c.Created DESC
Please Help!!!!
Auday
*** Sent via Developersdex http://www.developersdex.com ***
Navigation:
[Reply to this message]
|