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 |
|
flanz_g
Starting Member
22 Posts |
 Posted - 2006-11-14 : 16:47:27
|
| Have built tables with stitistical data (very large)in SQL Server 2000All with 2 fields in common: "Node" and "Datestamp"At the moment none is indexed.Tables will have joins added in Business Objects Universe.How do I know if adding indicis would improve speed of queries? And if so how are these best added? Do all tables need indicis or just some?What does it mean to Optimise the db above adding Index columns?Can the DB be made optimise itself automatically?Any prompts very appreciated,Gezza |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-11-14 : 17:32:52
|
| Read up on the the Index Tuning Wizard in Query Analyzer, the Show Execution Plan tab, and have a good look around this web sitesql-server-performance.com |
 |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-11-14 : 17:35:32
|
| Welcome to SQL Team Gezza!Begin by reading the documentation in BOL about indexes.Answers to your questions:Test.CREATE INDEX statement.Most, it depends.Too broad a topic.Not really.rockmoose |
|
|
|
flanz_g
Starting Member
22 Posts |
Posted - 2006-11-15 : 06:53:28
|
| Off to a rocky start then. Thanks Chaps |
|
|
|
|
|
|
How to "Optimise" an SQL 2000 db?