diff options
author | drh <> | 2025-05-14 16:40:05 +0000 |
---|---|---|
committer | drh <> | 2025-05-14 16:40:05 +0000 |
commit | 691b44a1b3808855c2095d26f721b5ee8aad48a0 (patch) | |
tree | f9933d09e72ff1311cdec932e6d8181a7d0a3341 /src/analyze.c | |
parent | c02ac7b9d7e5ac6a9b60fb80fec1f713c985d42b (diff) | |
download | sqlite-691b44a1b3808855c2095d26f721b5ee8aad48a0.tar.gz sqlite-691b44a1b3808855c2095d26f721b5ee8aad48a0.zip |
Back out the "low-quality index" query planner hack of check-in
[bcac937526d9a6ef]. Subsequent query planner enhancements for dealing
with star-queries make that change unnecessary and the change was recently
found to cause a performance regression in an unrelated query.
Also fix a typo in a debugging message.
FossilOrigin-Name: e7dcf25efae364b7cdf9eb8265803c816c8b8557e4a7684da428badc6ffb3875
Diffstat (limited to 'src/analyze.c')
-rw-r--r-- | src/analyze.c | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/src/analyze.c b/src/analyze.c index 8ca0e3e74..2721f2523 100644 --- a/src/analyze.c +++ b/src/analyze.c @@ -1576,16 +1576,6 @@ static void decodeIntArray( while( z[0]!=0 && z[0]!=' ' ) z++; while( z[0]==' ' ) z++; } - - /* Set the bLowQual flag if the peak number of rows obtained - ** from a full equality match is so large that a full table scan - ** seems likely to be faster than using the index. - */ - if( aLog[0] > 66 /* Index has more than 100 rows */ - && aLog[0] <= aLog[nOut-1] /* And only a single value seen */ - ){ - pIndex->bLowQual = 1; - } } } |