Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2002-09-02 : 04:27:21
|
| Hi ,I want to define Indexes on a database with around 10 GB .I want to know how to define indexes i.e on what basis Indexes should be defined( Clustered or Non-clustered ) I tried the Index tuning Wizard but it says to define the workload file or the trace file . My server is SQL 2000 with SP 1 Std. Edition. Can i get some help in knowing what exactly does that mean and how to generate a workload file so that i can proceed with the Index Tuning Wizard .ThanksAdmin001 |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2002-09-02 : 04:36:49
|
| Hi Admin001!If you've found the Index tuning Wizard, then you should have noticed the little button that says "Help". Everything you need to know about making a workload or a trace file is described in BOL. Defining indexes on a 10 gig database is not a childs play. There is more to it than only clustered or not clustered. Before you step into a job like this, read more books on DB administration. If you don't know in depth what you're doing, leave it "as is" and call a MCDBA to do the job. Until he arrives keep your fingers crossed! |
 |
|
|
|
|
|
How to define Indexes .