|
|
Posted by Matik on 09/30/05 19:14
Thanks Hugo and SQL :)
I see, that there is no better way, like just experiment with this
indexes, and maybe modify some statements. During past two days, I've
did that, and now is much better.
Anyway, the structure of the tables is bad, so there is also no
possibility to use better indexing.
I've one more question, if we are already by the topic of indexes. My
question is about the phisical memory the indexes are using.
When I've made all tables empty, truncated db, shrinkt aso. but the
file size is still a little to big. I know, that the indexes are taking
also memory to be stored (specialy clustered), but, after I've removed
all data, the indexes should be also cleared, right? Or maybe I need to
rebuild them?
Gratings
Mateusz
Navigation:
[Reply to this message]
|