Indexing a Table

[PaulHamill]

All

I am using SQL Server 7.0 and recently I used a utility with SQL Server 7.0 that would choose the best index to use on a table. I cant remember what this was called, can any one help. I know I didnt use the Profiler option.

Thanking you all in advance

 

[ClaireHCM]

Are you talking about index tuning wizard or create index wizard?

Both can be called by expanding any database ---Tools -- Wizards

From profiler you can call index tuning wizard,too.

 

[PaulHamill]

I dont think I used Profiler as I dont really understand what is going on there. I used a utility that looked at the data in the table and the structure and recommended which index to use. Create index wizard appears to only help be create an index