distributing data across tables

2001-02-07 Thread Kent Hoover
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

distributing data across tables

2001-02-06 Thread Tom Fishwick
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