yes, the index will be less compact, due to having a larger average row
length due to having the number in it.
if you know how many rows/<date interval> is possible, you could have
the sequence have that as its maxvalue and have it cycle. say that
you're using bulk collects and you can insert 1000 rows/sec. you could
have the sequence set to a maxvalue of say 10000 and have it cycle, so
that you would only be using smaller number values, and not end up with
values of the order of (number_of_months * 5,000,000).
-bdbafh
Received on Mon Jan 10 2005 - 16:01:11 CST
