Walter Meester
HoogkarspelNetherlands
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi hilmar,
>>You can split the table in two vertically: This means you have one PK commonly in thos table, but for the rest of the columns you spread them over those two files. Of course you'll have to adapt your program.
>
>Horizontally, too: for instance, one table for each year or month, or by geographical regions. This may required major rewrites of the programs.
I know, but gareth specifically asks for a solution to have 12 tables of arround 2 gig into one table. IOW he has partitionated them horzontally and is looking for an alternative.
Walter,
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only