Re:Index use problem

Philippe, You need to perform an "update statistics " as recommended in the SQL syntax guide ( medium with distributions only for table, high on all columns heading an index, and low on all other index columns ) That will definitely help. Sujata ____________________Reply Separator____________________ Subject: Index use problem Author: "Ph. Meylan" <meylan@steria.ch> Date: 11/20/97 2:37 PM 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