MS SQL Server - Index or not index ... this is the questions

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Index or not index ... this is the questions

Massimo M.

2006-03-14, 1:23 pm

I'm working on a table with 15,000,000 records with no index.
Today I put an index on a column subject to where statement.
I try on query analizer my query , with and without index, and I saw the
better time of the first solution; but, using the same query on a c# web app,
is the second solution to have the better exec time.
The results displed are only 100 so I don't think about network or rendering
issues.
Should be a problem about index rebuilt ???
I saw on performance monitor the hard work of index searches/sec in
sqlserver:access methods...
thx for attention
bye Massimo

Sponsored Links