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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-17 : 09:59:48
|
| Bala krishna writes "What is the difference between clustered and non-clustered indices? DBCC command used for.......How can you force the optimiser to use a particular index?" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-17 : 10:25:52
|
| clustered index puts the rows physically in that order on the disk. The advantage is that it's normally a faster SELECT. The disadvantage is that whenever you INSERT / DELETE rows, you have to move records around on disk, which can take time.Non-clustered stores the records in the order they were inserted. So, slower SELECTS, but faster INSERT / DELETE.MichaelYou'll need to look up the DBCC stuff in the Books Online.<Yoda>Use the Search page you must. Find the answer you will. |
 |
|
|
shsmonteiro
Constraint Violating Yak Guru
290 Posts |
Posted - 2002-07-17 : 16:40:12
|
| To force the optimizer to use a specific index:Select a, bfrom table (INDEX=index_name)And what you need to do with DBCC?Sérgio Monteiro |
|
|
|
|
|
|
Cluster,DBCC