T
Thomas Mercer-Hursh
Guest
Gus, how true is this in practice. I can see that, if one is doing a table scan regularly and there is a benefit in doing the table scan in the order of a particular index, that the performance would be better if the physical layout matched the logical one. But then, one rarely wants to be doing a table scan and, with a sufficiently modern version of Progress, using the table-scan option *instead* of any index is going to be preferred. Certainly, finding individual records the physical order should be irrelevant. I suppose I can see that, if one is finding a group of records and the bracketing is occurring on the same index which determined the physical ordering, that there might be a slight benefit, but how common or significant is that really. I thought the idea these days was that routine dump and load as a maintenance strategy was not warranted.
Continue reading...
Continue reading...