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 |
|
Mohansoft
Starting Member
6 Posts |
 Posted - 2005-09-05 : 11:05:05
|
| What is the diferrence between clustered and nonclustered indexes.what is their perfomance difference.Maximum of how many nonclusteredindexes we can have in a table.When there are more than one index in a table how can we use one particular index for selecting rows from a table.D.Mohan Raj |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-09-05 : 15:04:22
|
| Have a look at indexes, clustered and indexes, nonclustered in bolcapacity specifications in bolBy doing a select on the indexed columns? That's if the table isn't too small for the index to be useful.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-05 : 15:36:20
|
| "What is the diferrence between clustered and nonclustered indexes"One clusters the data with the index, the other one doesn't."what is their perfomance difference"One is faster than the other, the other ones isn't."Maximum of how many nonclustered indexes we can have in a table"One can have one, the other one can have more than one."When there are more than one index in a table how can we use one particular index for selecting rows from a table"One uses hints, the other uses the optimiser.Kristen |
|
|
|
|
|
|
DBCC and Indexes