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 |
|
lcpx
Yak Posting Veteran
54 Posts |
 Posted - 2005-12-09 : 05:11:03
|
| We have a table which contains 135,000 rows, around 20 colomns, there is no long text in the table, just some numbers,date and char type data, but I don't know why it takes 760M space in hard disk. And each time when I make a query towards that table, it's running extremely slow. I've also built few indexes on the table, but it doesn't really help.We got another similiar table, contains the very similiar data with 110,000 rows, but it only take 60M.Can anybody tell me why, and is there any way I can optimize the table. Appreciate any thought you have on it!Cheers! |
|
|
surendrakalekar
Posting Yak Master
120 Posts |
|
|
lcpx
Yak Posting Veteran
54 Posts |
Posted - 2005-12-09 : 07:32:57
|
| Thanks very much, I'll have a read in detail.Cheers! |
 |
|
|
|
|
|
|
|
why the table takes so much space?