Simon Riggs wrote:
...REINDEX...CREATE/DROP INDEX...
I'm curious if partitioning can help help
provide online create/reindex.
For example, if I could set set up a table
partitioned by "modified time"; could I make
a new partition so all new inserts go into a
new partition and then I can re-index / create-index
on the old partitions concurrently because only
reads and deletes would be happening on that
old table?
The new partition would have a new index anyway
so no reindex would even be needed on that part.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
