September 10, 2008 at 6:30 am
Hey Guys,
I need some help for better managing big tables.
I currently have a table with about 150 MM rows and i have to do a lot of selects from it.
I'd like to know what is the best way of using this amount of data? Should i divide the table in various tables and then do a view? Or what about those indexed views i've heard about. I did some research but really didnt understand much about it.
Any help would be really appreciate it.
September 10, 2008 at 7:29 am
In order to give the best answer we need to know how the table is queried, what kind of indexes exist, what datatypes are the columns which are typically used as search arguments, is the table mainly used for select queries or does it have a lot of inserts and/or updates etc.
If you typically query for records within a certain range, you might want to place a clustered index on the range column. Another option might be partitioning the table and indexes.
Indexed views can help but you have to be aware of the fact that they also add some extra overhead especially if you do a lot of inserts/updates/deletes.
[font="Verdana"]Markus Bohse[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply