aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authordrh <>2025-01-03 11:51:50 +0000
committerdrh <>2025-01-03 11:51:50 +0000
commitded37f337b7b2e916657a83732aaec40eb146282 (patch)
tree6775049c348cbdd70493a2aba6604c4d415ca344 /src
parent8d6e3f513c049a07d34f77ab526259c916418af6 (diff)
downloadsqlite-ded37f337b7b2e916657a83732aaec40eb146282.tar.gz
sqlite-ded37f337b7b2e916657a83732aaec40eb146282.zip
Add comment to the columnIsGoodIndexCandidate() routine to record the results
of a failed experiment. No changes to code. FossilOrigin-Name: 9ee57a30a49d9813bf2669a5d8346f7e018e3fbf1792739951311a8d3a249d45
Diffstat (limited to 'src')
-rw-r--r--src/where.c5
1 files changed, 5 insertions, 0 deletions
diff --git a/src/where.c b/src/where.c
index c9698699b..4325374bc 100644
--- a/src/where.c
+++ b/src/where.c
@@ -860,6 +860,11 @@ static int constraintCompatibleWithOuterJoin(
** more than 20, then return false.
**
** 3. If no disqualifying conditions above are found, return true.
+**
+** 2025-01-03: I experimented with a new rule that returns false if the
+** the datatype of the column is "BOOLEAN". This did not improve
+** performance on any queries at hand, but it did burn CPU cycles, so the
+** idea was not committed.
*/
static SQLITE_NOINLINE int columnIsGoodIndexCandidate(
const Table *pTab,