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@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
