Re: Trun Off Indexes!

Posted in 1999

Mark D. Stock — Sun, 30 May 1999 20:07:05 +0200 — source: Informix-list mailing list archive (1991-1998)

"Carlson@WHSmith" wrote: > > But which is faster, enable / disable or drop / recreate? > > I've always dropped and recreated, myself. DISABLE/ENABLE will be slightly quicker, but not a lot of difference in performance. The other advantage is not having to find the latest syntax every time you need to do this. You can run ENABLE with no knowledge of the original CREATE command. Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |What year 2000 bug? year 2000 bug? |/// / ////| | Fax: +27 838250 2325 |year 2000 bug? year 2000 bug? year |// / /////| |Cell: +27 83 250 2325 |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+