I have a session that performs very badly but only in one company. I suspect that the table index may be corrupted. Is there a method to check if this is so?

Ev

With Oracle Level 2 it is VERY rare to have a corrupt index.

More likely your statistics are out of date or you're missing the index entirely.

Of course I'm assuming that the tables are in the same database, and are about the same size, and your DB is tuned. If not then you have a lot more to look at.

Dave

Thanks Dave. I also heard from another source that indexing is not the problem in this case so I am pursuing it from other angles. We used to run Informix as our database and had indexing problems all the time... good to know that Oracle doesn't have this problem.:)

Sounds good! good luck with it! let me know if i can help any more!

Dave

You can try to run the session - Check Tables - ttaad4232m000, which might give this error code in case of problems -

305 ESQLWRONGROW
This occurs when a wrong record was returned. It probably means either that the table index is corrupt or that the RDBMS has a different sorting order than the BaanERP software.

My 2 cents:
- for Baan or database tracing I like to refer to my document:
Performance Tracing and Tuning Guide (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=7665)
- About checking indexes I had seen the attached session.

Hope it helps,
Dick

The decision of this problem is recovery for sql server (http://www.recoveryforsqlserver.com). The program can show the results of working with lost or crashed sql server files. It starts under any software configuration of your system. The tool uses modern methods of restoration info.