Wednesday, June 28, 2006, 2:04:17 Simon Riggs, you wrote:
> That part is sensible. The min_IO_cost is when the access is sequential,
> which by definition has a cost of 1.0.
In general - yes. But we talk about the min_IO_cost of the index scan which is
barely sequential. Correct me if I'm wrong:
Hello all
I have a big amount of phone calls data (280M records, 25 Gbytes).The best
decision
for this task is partitioning and I use it now. But at first I tried put all
data in a single table indexed by call date&time. Because of nature of the
data the records clustered by date and near ordered
