|
Is it possible to have a partitioned table with some of its filegroups in read/only mode?
(comments are locked)
|
|
Readonly filegroups have benefits around locking and backups, so partitions that are spread across a combination of writable and readonly partitions can give major benefits. It's most definitely encouraged...
(comments are locked)
|
|
Yes, that's one of the main reasons for setting up partitioning. Grant: I thought the main reason for partitiong was speeding up your queries against big tables; what about parallel processing?
Oct 27 '09 at 04:23 PM
Alberto De Rossi
Xactly. Speed up processing. Read only file groups are going to process quite a bit faster than ones that can take data.
Oct 27 '09 at 06:41 PM
Grant Fritchey ♦♦
(comments are locked)
|
|
I have any application which has old data (as old as 8 years). we are thinking of paritioning into RO and RW partitions. but sometime the older data gets modified. So how do we move data from Read Only Partition to Read Write Partitions before we can modify the data? @Ramakrishnan Nagasamy, Please ask your comment as a new question so that your question will get more attention and response
Jan 24 '11 at 11:02 PM
Cyborg
(comments are locked)
|
