On Thu, Jan 26, 2006 at 04:14:45PM -0500, Chris Browne wrote:
> > As for Reindex, I'm not entirely sure, I don't think you would benefit
> > from reindex because you aren't updating or deleting. Can anyone comment
> > on this? Is is possibile that a table with lots of inserts resulting in
> > lots of page splits etc could ever benifit form REINDEX?
>
> I could imagine a CLUSTER doing some good, and if that's the case,
> REINDEX could have some favorable results. But you'd better have a
> real specific model as to why that would be...
Aside from the cluster case, are there any issues with how page splits
in the b-tree are done that could lead to better performance after a
REINDEX?
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461