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 |
|
nishita_s
Yak Posting Veteran
61 Posts |
 Posted - 2010-02-16 : 02:00:22
|
| I have crore rows in one table, there are 57 columns and 20 indexes.So while retrieving data or performing operations it is taking too much time,So can anyone suggest how to improve performance?? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-16 : 02:13:25
|
| why dont you try partitioned tables?http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 02:39:24
|
| Lets see the query plan, then people can make suggestions for improvements. |
|
|
|
|
|
|
Performance problem