Tom,
Read about the MERGE TABLE type, which might satisfy your needs. It
allows
you do partitioning, and to index across partitions, but it does have
some
limitations.
Cheers,
Kent
-
Before posting, please check:
http://www
hi!
I'm going to be building a system that will need to handle a fair bit of
data...
Basically I have tables that will eventually have millions of rows of
data, I believe I need to split them up for 2 reasons, 1, performance
(the tables will be quite active), 2, if a table get's corrupted then