Hello:
A table of 24M records is keyed on a btree index of unique values. Records are generally appended to this table. Records are occasionally replaced (rather than modified) by deleting and then appending similar or even identical data. Rarely are records permanently deleted from the table. Will the btree index on this table benefit from a merge? How can I tell? Are there graphical or tabular metrics that I can review to show me the number of inactive (deleted) index values relative to the entire index structure? Knowing how much the index will shrink, and how long it takes to regenerate the btree index from scratch, can I reliably guestimate how long the modify... to merge will take? Cheers! Dave Dave Marvin Columbia Basin PIT Tag Information System Pacific States Marine Fisheries Commission [email protected] <mailto:[email protected]>
_______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
