Mindaugas wrote:
And I cannot use some index organized table or table partitioned by From :)
because there are at least 2 similar indexes by which queries can be executed -
From and To.
This makes things a bit tough. One trick is to vertically partition the
table into two new tables - with "From" in one and "To" in the other...
then you can (horizontally) partition or cluster on each of these
columns separately.
You can make it reasonably transparent by using a view to combine the
columns again to get something that looks like the original table.
Cheers
Mark
---------------------------(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
