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,
Jamescheck 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
>