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 |
|
sent_sara
Constraint Violating Yak Guru
377 Posts |
 Posted - 2007-07-26 : 12:11:03
|
| for what purpose we are splitting the non-clustered index into 3 instead of 1create index si_acct_info_dtl_INDX1 on si_acct_info_dtl(account_code, ctrl_acct_type)create index si_doc_hdrfk_ci_acct_info_dtl on si_acct_info_dtl(tran_ou, tran_type, tran_no)whether index rebuit everycolumn when search is given????.if we build the index in onestatement like this:create index si_acct on si_acct_info_dtl(batch_id)create index si_acct_info_dtl_guid on si_acct_info_dtl(batch_id,account_code, ctrl_acct_type,tran_ou, tran_type, tran_no) |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-07-26 : 12:21:12
|
| Are you asking us why you are doing something?CODO ERGO SUM |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-07-26 : 15:33:13
|
| maybe because the covering index doesn't satisy your queries??_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-07-26 : 15:54:50
|
| you need to understand how indexes work. The first key in the index is crucial in determining if SQL server is going to use it or not. That is usually why you will see several smaller (fewer column) indexes instead of one large compound index.-ec |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-26 : 22:44:55
|
| Sql doesn't rebuild index when you run query. |
|
|
|
|
|
|
Index tuning