Re: Index use problem

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