ANALYZE - Currupting Index

From: Jay <jaynet_at_concntric.net>
Date: 1996/10/06
Message-ID: <32585985.5E63_at_concntric.net>#1/1


Environment: VAX VMS - Oracle 7.1 Visual Basic Front end. Problem:

Some one's argument is whenever an "ANALYZE table Validate Structure" is run it is validating without any error messages but currupting the index.

The basis for arguement is:  

When the "ANALYZE table Validate Structure" is not run the response time is very fast and as soon as the person runs the "ANALYZE table Validate Structure" the response time becomes terribly slow.

But "ANALYZE" is supposed to analyze the table and show if the index is corrupted. Instead in this case it is corrupting the index.

Could this true? Did any one faced this type of problem in the past? If so what could be the reason and what is the solution? Received on Sun Oct 06 1996 - 00:00:00 CEST

Original text of this message