removing index scan and table scan

How can I remove index scan to occure in my SPROC's execution plan.
I would like to replace them with index seek.
~Alok.
hi Alok,
"Alok" <itsalok2040@.hotmail.com> ha scritto nel messaggio
news:ekDgnzvhEHA.2624@.TK2MSFTNGP12.phx.gbl...
> How can I remove index scan to occure in my SPROC's execution plan.
> I would like to replace them with index seek.
the plan you get when the actual statement is executed depends on your
actual data and metaschema involved in the query...you can submit a hint in
the SELECT statement to force SQL Server to use a particular index, but you
can not force it to perform an actual index seek instead of an index scan...
you can try fine tuning your database uisng the Index Tuning Wizard in order
to see eventual feedback from your workload(s), which could hints for
additional index(es) to better fullfill your statements
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply