diff options
| author | drh <drh@noemail.net> | 2013-03-27 16:05:30 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2013-03-27 16:05:30 +0000 |
| commit | 2b6c874b13b649ce31eb8907ec1faa261536a2bf (patch) | |
| tree | 8e3b7dd608ad1c286ffdedfd0e066fbfddf17c92 /src | |
| parent | 8a1b87cb971a52b9d782def9b70827d9fc302a3f (diff) | |
| download | sqlite-2b6c874b13b649ce31eb8907ec1faa261536a2bf.tar.gz sqlite-2b6c874b13b649ce31eb8907ec1faa261536a2bf.zip | |
Improved optimization of ORDER BY.
FossilOrigin-Name: 97e5c70f2f19a1bca70dd2221b757b9e5418fce0
Diffstat (limited to 'src')
| -rw-r--r-- | src/where.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/where.c b/src/where.c index 323b568c8..409d73a05 100644 --- a/src/where.c +++ b/src/where.c @@ -3486,7 +3486,8 @@ static void bestBtreeIndex(WhereBestIdx *p){ ** So this computation assumes table records are about twice as big ** as index records */ - if( (pc.plan.wsFlags&~(WHERE_REVERSE|WHERE_ORDERED))==WHERE_IDX_ONLY + if( (pc.plan.wsFlags&~(WHERE_REVERSE|WHERE_ORDERED|WHERE_OB_UNIQUE)) + ==WHERE_IDX_ONLY && (pWC->wctrlFlags & WHERE_ONEPASS_DESIRED)==0 && sqlite3GlobalConfig.bUseCis && OptimizationEnabled(pParse->db, SQLITE_CoverIdxScan) |