Indexing

Throughout the course of trying to optimize our database (not really my
position)...the topic of indexing has come up. Our IT department is pretty
feeble and no one (who should know) seems to know what it involves. Are
there any decent resources regarding what it is and how to effectively use
it?
Thanks,
JamesThis is a huge topic. See SQL Books Online. (BOL) Make
sure to thoroughly understand where they should be put
before you start applying them all over the place. (Its
been known to happen.)
>--Original Message--
>Throughout the course of trying to optimize our database
(not really my
>position)...the topic of indexing has come up. Our IT
department is pretty
>feeble and no one (who should know) seems to know what it
involves. Are
>there any decent resources regarding what it is and how
to effectively use
>it?
>Thanks,
>James
>
>.
>|||check out www.Sql-Server-Performance.com
I recommend load testing before and after all changes to compare all deltas.
If you want more specifics, post back and I'll provide more info...
Greg Jackson
PDX, Oregon|||www.sql-server-performance.com has various articles that might help you.
I would also recommend picking up Ken England's _Microsoft SQL Server 2000
Performance Optimization and Tuning Handbook_ on Digital Press.
"James Baker" <cppjames@.hotmail.com> wrote in message
news:OyisojnaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> Throughout the course of trying to optimize our database (not really my
> position)...the topic of indexing has come up. Our IT department is
pretty
> feeble and no one (who should know) seems to know what it involves. Are
> there any decent resources regarding what it is and how to effectively use
> it?
> Thanks,
> James
>