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 |
|
pushp82
Yak Posting Veteran
83 Posts |
 Posted - 2012-01-19 : 05:29:52
|
| Hi Friends,We are in stage to live our web in few days. so in this case I want some help from expert that: How can I determine if we need index on tables as we have primary key (clustered) on all tables?I there any exercise available that can help me.. prior to live our database......?You may think me dumb here but I need answer here...thanks in advance...Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-01-19 : 05:48:32
|
| If you have anything more than a handful of rows and you're ever filtering or joining on columns other than the primary key, then you need indexes. That's the short of it.[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP |
 |
|
|
pushp82
Yak Posting Veteran
83 Posts |
Posted - 2012-01-19 : 07:37:41
|
quote:
Originally posted by GilaMonster
If you have anything more than a handful of rows and you're ever filtering or joining on columns other than the primary key, then you need indexes. That's the short of it.[url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/[/url][url]http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/[/url]--Gail ShawSQL Server MVP
thank you!!! information was helpfull. |
|
|
|
|
|
|
How to determine if index require