diff options
| author | drh <drh@noemail.net> | 2020-10-22 18:50:30 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2020-10-22 18:50:30 +0000 |
| commit | beb22d086bae43a3e21ee140af3a9c8e369939d9 (patch) | |
| tree | ce05e1e56d0266eefdc58de62f37fe6139a75b2d /src/analyze.c | |
| parent | 672f07c642fad9ad76b1a8cd1c1d196d0286ffc4 (diff) | |
| parent | 461ff3594b86506d4d4c4294be336d5da2757cd8 (diff) | |
| download | sqlite-beb22d086bae43a3e21ee140af3a9c8e369939d9.tar.gz sqlite-beb22d086bae43a3e21ee140af3a9c8e369939d9.zip | |
Minor tweaks to query planning weights so that when STAT4 is enabled
and functioning, a full table scan is more likely to be selected if
that seems like the fastest solution. Only do this when STAT4 info
is available because an error has a large potential downside.
FossilOrigin-Name: 0e7e113d9f2c929c1f8a85e2cfad8e2e60f0e8770212b5e5320fb2a2c42911f8
Diffstat (limited to 'src/analyze.c')
| -rw-r--r-- | src/analyze.c | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/src/analyze.c b/src/analyze.c index 9a9de991d..dc77220a5 100644 --- a/src/analyze.c +++ b/src/analyze.c @@ -1772,6 +1772,7 @@ static int loadStatTbl( } pSpace = (tRowcnt*)&pIdx->aSample[nSample]; pIdx->aAvgEq = pSpace; pSpace += nIdxCol; + pIdx->pTable->tabFlags |= TF_HasStat4; for(i=0; i<nSample; i++){ pIdx->aSample[i].anEq = pSpace; pSpace += nIdxCol; pIdx->aSample[i].anLt = pSpace; pSpace += nIdxCol; |