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 |
|
sbalaji
Starting Member
48 Posts |
 Posted - 2007-11-01 : 18:24:18
|
| I have a table<table1> with 804668 records primary on table1(col1,col2,col3,col4)Have created non-clustered index on <table1>(col2,col3,col4),to solve a performance issue.(which is a join involving another table with 1.2 million records).Seems to be working great.I want to know whether this will slow down,insert and update on the <table1>? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-11-01 : 18:28:33
|
| yes it will.since it will have to reorganize the clustered index.i hope you're not updating parts of your PK_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
 |
|
|
sbalaji
Starting Member
48 Posts |
Posted - 2007-11-01 : 18:42:16
|
quote:
Originally posted by spirit1
yes it will.since it will have to reorganize the clustered index.i hope you're not updating parts of your PK
ok,Will check invoice creation and edit,will have to arrive at compromise strategy.Thanks for the reply. |
|
|
|
|
|
|
Clustered and Non clustered index on same columns