Hi,
Are there any references on the basics of indexing?
I am not very familiar with a lot of concepts and dont have the time to
become an expert.
However, I would like to speed up my processing time. This is quite
important since I get
the results back to a VB front-end and long delays tend to hung the
application.
TIA
-stevesql-server-performance.com is a good place to start.
If you don't want to tune queries yourself, then SQL Server provides an
Index Tuning Wizard in Query Analyzer. This will recommend indexes, based on
the provided workload.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"steve" <steve@.here.com> wrote in message
news:FwNbe.31823$iP.563299@.weber.videotron.net...
Hi,
Are there any references on the basics of indexing?
I am not very familiar with a lot of concepts and dont have the time to
become an expert.
However, I would like to speed up my processing time. This is quite
important since I get
the results back to a VB front-end and long delays tend to hung the
application.
TIA
-steve|||In this link look the tips for indexes.
http://www.sql-server-performance.com/
AMB
"steve" wrote:
> Hi,
> Are there any references on the basics of indexing?
> I am not very familiar with a lot of concepts and dont have the time to
> become an expert.
> However, I would like to speed up my processing time. This is quite
> important since I get
> the results back to a VB front-end and long delays tend to hung the
> application.
> TIA
> -steve
>
>
Monday, February 20, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment