Re: [sqlite] Indexes analysis

2006-10-31 Thread drh
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

[sqlite] Indexes analysis

2006-10-31 Thread chetana bhargav
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