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.
David Williams — — source: Informix-list mailing list archive (1991-1998)
In article <651elc$bo8$1@news.eunet.ch>, "Ph. Meylan" <meylan@steria.ch>
writes
>Hello,
>
>we have the following problem, under 7.13 on AIX :
>
>1) We had a table with three indexes. That table moved from one physical
>device to another one ( The indexes are on a third device). After this
>operation we seen that the index was no more used by the query we did.
>
>2) We tried to drop and rebuild the indexes unsuccessfully. The table is
>continously accessed sequentially.
>
>3) We remove the table on the original device without result.
>
>4) And we rebuild on more time the indexes. No success.
>
>At this stage we don't know what we can doing to restablish the normal use
>of the indexes, and an help will be highly appreciated.
>
>Best Regards
>
>Philippe Meylan
>
>Geneva, Switzerland
>
>
update statistics for table <tablename>
--
David Williams
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.