Re: Dropping/Recreating Index vs Setting Disable/Enabled
TM Chan wrote: > > --------------2276CDBC9695D9EC70A4880D > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > Hi, > > I need to drop/create index for a very large volatile table(> 1 > million rows) frequently to enhance performance. If the index has > become inefficient, does disabling and enabling the index rebuild the > entire index tree like what dropping and creating the index do or does > it merely updates the index tree? If they behave differently, which of > these two methods will give a better performance in terms of query > optimization? > Any help is appreciated. > > Regards, > TM Chan > > --------------2276CDBC9695D9EC70A4880D > Content-Type: text/html; charset=us-ascii > Content-Transfer-Encoding: 7bit > > <!doctype html public "-//w3c//dtd html 4.0 transitional//en"> > <html> > <font size=-1>Hi,</font><font size=-1></font> > <p><font size=-1> I need to drop/create index for a very > large volatile table(> 1 million rows) frequently to enhance performance. > If the index has become inefficient, does disabling and enabling the index > rebuild the entire index tree like what dropping and creating the index > do or does it merely updates the index tree? If they behave > differently, which of these two methods will give a better performance > in terms of query optimization?</font> The two are the same, so performance should be very similar. But I don't see why dropping and re-creating an index will improve performance? I'd be interested to hear the logic behind that theory. Unless you are creating a cluster index of course. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock http://www.informix.com |//////// /| | mailto:mdstock@mydas.freeserve.co.uk |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+