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 |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2007-10-13 : 07:21:53
|
| Below given are index created in my table.I wish to know here index key ACTION_CD, PRD_CD,ST_ALPH_CD,STS_CD are created in separate name.if i create these four in single name , mean that single non clustered index instead of four index, will it improve performance. but i can use 2 column (PRD_CD) alone , or 3rd column(ST_ALPH_CD) alone .So in that case also index scan will be applied??also if i do this memory size also will get reduce ???PK_Quote nonclustered, unique, primary key located on PRIMARY QT_SYSKEYQuote_ACTION_CD nonclustered located on PRIMARY ACTION_CDQuote_PRD_CD nonclustered located on PRIMARY PRD_CDQuote_QT_ACTIVITY_DT clustered located on PRIMARY QT_ACTIVITY_DTQuote_ST_ALPH_CD nonclustered located on PRIMARY ST_ALPH_CDQuote_STS_CD nonclustered located on PRIMARY STS_CD |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-13 : 21:35:30
|
| Depends on what kind of queries you run against the table. |
 |
|
|
|
|
|
INDEX CREATION ANALYSIS