[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] Indexes analysis
From:       drh () hwaci ! com
Date:       2006-10-31 11:53:36
Message-ID: 2454039.9950316355561927783172715279148278641542917589 () hwaci ! com
[Download RAW message or body]

chetana bhargav <bhargav_chetana@yahoo.com> 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  <drh@hwaci.com>


-----------------------------------------------------------------------------
To unsubscribe, send email to sqlite-users-unsubscribe@sqlite.org
-----------------------------------------------------------------------------


[prev in list] [next in list] [prev in thread] [next in thread]