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 |
|
loudbliss
Starting Member
37 Posts |
 Posted - 2008-09-10 : 08:40:13
|
| 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 dealing with 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. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-09-10 : 09:19:44
|
Yes you can index a view. You only have to comply to a list of 21 items.If one of them is not fulfilled, you can't create the view.Or you could try to partition your data.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
|
|
|
Indexed Views