Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
TM Chan — — source: Informix-list mailing list archive (1991-1998)
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
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.