Hi, I am trying to analyze index usage for my queries for performance.
Basically I found two methods, One of them EXPLAIN QUERY METHOD. And the other is idxChk tool. My DB is of latest version of 3.3.8. When I checked for idxChk tool page it says it was tested only till 3.2.7. Just wanted to know is it still supported on latest version also. And regarding EXPLAIN QUERY METHOD, I seem to be getting some error. It just says, "0|0|TABLE table_acc WITH INDEX IDX_ACC_ID_STATE" But when I try to use EXPLAIN its giving complete info. Just wanted to know whats the error. Is the above statement is correct or what? Is there any way to interpret this. ... Chetana.