chetana bhargav <[EMAIL PROTECTED]> wrote: > > 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" >
This is not an error. It is the output of EXPLAIN QUERY PLAN. This says that you are reading the table "table_acc" and that it is using the "idx_acc_id_state" to speed the search of that table. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------