Re: Index use problem

Has update statistics been run on the table since it was moved? >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 > > Madison Pruet