Re: Should I Index?
From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 06/03/04
- Next message: Paul Ibison: "Re: System user account versus domain user account"
- Previous message: Wayne Snyder: "Re: System user account versus domain user account"
- In reply to: John Bandettini: "RE: Should I Index?"
- Next in thread: David Browne: "Re: Should I Index?"
- Reply: David Browne: "Re: Should I Index?"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 3 Jun 2004 08:38:44 -0400
If these tables are intermediate tables which will be used frequently in
joins, (and they are larger than 10 pages, and sometimes the joins should
return fewer than 5% of the rows in the table.) then absolutely positively
index them.
-- Wayne Snyder, MCDBA, SQL Server MVP Mariner, Charlotte, NC www.mariner-usa.com (Please respond only to the newsgroups.) I support the Professional Association of SQL Server (PASS) and it's community of SQL Server professionals. www.sqlpass.org "John Bandettini" <anonymous@discussions.microsoft.com> wrote in message news:FA88F208-6521-40A7-88D2-922FDCF7824E@microsoft.com... > Keith > > You should create indexes if your application will use them. What I mean is it is not useful to have indexes that are not used. Indexes are at their most useful when you have queries that only bring back a small portion of the data or a defined range of data. > > A good place to start is the index tuning wizard. Capture some data on the application as it is being used. Use profiler to do this. Save the output from profiler to a file. Then run the index tuning wizard, it should suggest some suitable indexes based on the workload. > > These will get you started then it is just understanding your application, to know if any more would be suitable. > > See following link for tips on using profiler > > http://www.sql-server-performance.com/sql_server_profiler_tips.asp > > Hope this helps > > John
- Next message: Paul Ibison: "Re: System user account versus domain user account"
- Previous message: Wayne Snyder: "Re: System user account versus domain user account"
- In reply to: John Bandettini: "RE: Should I Index?"
- Next in thread: David Browne: "Re: Should I Index?"
- Reply: David Browne: "Re: Should I Index?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
