Re: [sqlite] Improving access speed to fetch indexed column.

The patch doesn't attached, please apply link to the patch. 2012/7/12 Filip Navara > This roughly resembles an issue I witnessed on our databases about > year ago (thread "Improving the query optimizer" on this mailing > list). SQLite doesn't use covering index for

Re: [sqlite] Improving access speed to fetch indexed column.

This roughly resembles an issue I witnessed on our databases about year ago (thread "Improving the query optimizer" on this mailing list). SQLite doesn't use covering index for fulfilling queries unless the query is filtered/ordered by a column included in the index. In many cases the covering

Re: [sqlite] Improving access speed to fetch indexed column.

On Wed, Jul 11, 2012 at 7:49 PM, Kohji Nakamura wrote: > Hello all, > > I found that the access to an indexed column without "order by" is slower > than the one with "order by" in SQLite 3071300. > Using an index rather than an actual column is faster even if there is no >

[sqlite] Improving access speed to fetch indexed column.

Hello all, I found that the access to an indexed column without "order by" is slower than the one with "order by" in SQLite 3071300. Using an index rather than an actual column is faster even if there is no need to use the index when the column has index. In general, to fetch column value,