Indexing my db

[KSO]

I have indexed my db and I don't think it has speeded it up at all !

Do I have to "build" the indexes or anything else ?

Best regards
KSO, Denmark

[vinu]

HI

Are you sure that the index are on the right column that the application
needed, have you updadted the STATISTICS

regards
vinu

"KSO" <k...@psa.dk> wrote in message
news:%2302aVHH...@TK2MSFTNGP05.phx.gbl...

[KS]

"... have you updadted the STATISTICS"

What do you mean ?

Best regards
KSO, Denmark

"vinu" <vinu....@gmail.com> skrev i meddelelsen
news:ulZlvIIz...@TK2MSFTNGP06.phx.gbl...

[Tibor Karaszi]

Indexing isn't as simple as just creating indexes and expecting something to execute faster. You
need to consider what indexes you are creating, and the indexes should be helpful for the queries
you are executing etc. This is why performance tuning is often performed by people with several
years of SQL server experience...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"KSO" <k...@psa.dk> wrote in message news:%2302aVHH...@TK2MSFTNGP05.phx.gbl...

[Russell Fields]

KS,

When you create new indexes they are built at that time, with no further
steps needed. Also, a new index has up-to-date statistics, so you should
not need to update them.

However, changes to data can cause the cached statistics on the row counts
per key ranges to age, so if an index has been around for a while, it may be
helpful to do an UPDATE STATISTICS or sp_updatestats. Also, you can defrag
the indexes using DBCC REINDEX or DBCC INDEXDEFRAG (or in SQL Server 2005,
ALTER INDEX ... REBUILD).

But, of course, the main issue is to create indexes that are useful to your
queries.

RLF

"KS soer...@os.dk>" <keld.<SLET_DETTE> wrote in message
news:4E3A4813-82C6-4D3C...@microsoft.com...