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 |
|
Kimi86
Yak Posting Veteran
79 Posts |
 Posted - 2014-07-29 : 13:01:23
|
| I have a weird issue..There were a few tables i had replaced with new data.the table structure is same just data has been refresh recently. New and the old data look almost same with few minor chnages to the valuesSo i rename the old table to <table>_oldAnd then recrete these table with new dataI also create all the indexes from old table to new one..However the performance of my queries is too slow after the chnage.. Same queries worked well with old table..Could someone please indicate wheat i might be missingI have also tried rebuilding all the indexesThere was one clusterd and 2 non clustered indexd on each of the tablesPlease help!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-29 : 13:04:27
|
| Show us the execution plan, the query and the index definitions.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
indexes not working