Explanation of INDEX(index, index, ...)

Hi everybody,
can someone explain me how to use :
SELECT foo FROM table (INDEX(indexA, indexB, ...))
Thanks,
ThierryBooksOnLine has a very good description of this feature under "index hints".
This should only be used as a last resort though and normally you want the
optimizer to choose the best index to use.
Andrew J. Kelly SQL MVP
"Thierry" <XXthierry_bXX@.ifrance.com> wrote in message
news:439db51f$0$20162$8fcfb975@.news.wanadoo.fr...
> Hi everybody,
> can someone explain me how to use :
> SELECT foo FROM table (INDEX(indexA, indexB, ...))
> Thanks,
> Thierry
>|||just to reiterate what Andrew said: this is a last resort, and one that
should only be used outside of production.
The optimizer is very good at choosing the right plan. When it doesn't,
it is usually due to poorly designed indexes or out of date statistics.
Having auto update stats on helps, but also ("belt and suspenders" as
they say) updating the statistics regularly, based on the frequency of
data changes. e.g., some tables are quite static, so they can be updated
once a month, some may require daily statistics updates.
Thierry wrote:
> Hi everybody,
> can someone explain me how to use :
> SELECT foo FROM table (INDEX(indexA, indexB, ...))
> Thanks,
> Thierry
>|||got it.
Is there some good sites that explain how to properly use indexes and how to
read results from execution plan ?
Also, how should I read values like 280.000 in performance monitor with
counter=Index searches/sec ?
Thanks,
Thierry
"Trey Walpole" <treypole@.newsgroups.nospam> a crit dans le message de news:
uKXf5w0$FHA.2736@.TK2MSFTNGP11.phx.gbl...
> just to reiterate what Andrew said: this is a last resort, and one that
> should only be used outside of production.
> The optimizer is very good at choosing the right plan. When it doesn't, it
> is usually due to poorly designed indexes or out of date statistics.
> Having auto update stats on helps, but also ("belt and suspenders" as they
> say) updating the statistics regularly, based on the frequency of data
> changes. e.g., some tables are quite static, so they can be updated once a
> month, some may require daily statistics updates.
>
> Thierry wrote:|||You may want to start here:
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
http://www.sql-server-performance.c..._showcontig.asp Understanding
DBCC SHOWCONTIG
Andrew J. Kelly SQL MVP
"Thierry" <XXthierry_bXX@.ifrance.com> wrote in message
news:439e9f95$0$6650$8fcfb975@.news.wanadoo.fr...
> got it.
> Is there some good sites that explain how to properly use indexes and how
> to read results from execution plan ?
> Also, how should I read values like 280.000 in performance monitor with
> counter=Index searches/sec ?
> Thanks,
> Thierry
> "Trey Walpole" <treypole@.newsgroups.nospam> a crit dans le message de
> news: uKXf5w0$FHA.2736@.TK2MSFTNGP11.phx.gbl...
>