Re: Maximum extents

hi, > Well, there is no fixed answer because it depends on the table. But > I've seen 200 in some documentation in the past. i think it is in the performance guide, i'm not sure. but no one has rasied the issue, why do you need to know? you take a performance hit when the number of extents is greater than 8, more than will fit on one page. the bottom line is that you should do everything you can to make sure that a table never has more than 8 extents. mickm