>I sure would hate to take too many CA splits in an on-line environment >especially if the CA split requires another extent for either the data and/or index component.
That's the whole point of "Demystified". The only cost of the split is at 'split time'. And, with today's disk and CPU capacity, even that is not that big of a cost. With today's caching, buffering, etc, there are more important issues than a SPLIT. PS: define 'too many'. - Too busy driving to stop for gas! ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
