Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
index_info.html

Index Summary Markup Original


R-56168-33548-13029-39450-16925-62002-00954-18437 tcl slt th3 src

The aConstraint[] array records WHERE clause constraints of the form:

column OP expr

where OP is =, <, <=, >, or >=.

/* IMP: R-56168-33548 */
# EVIDENCE-OF: R-56168-33548 The aConstraint[] array records WHERE
# clause constraints of the form: column OP expr where OP is =, <,
# <=, >, or >=.

R-22232-40047-05023-56174-19457-36430-27942-49450 tcl slt th3 src

The particular operator is stored in aConstraint[].op using one of the SQLITE_INDEX_CONSTRAINT_ values.

/* IMP: R-22232-40047 */
# EVIDENCE-OF: R-22232-40047 The particular operator is stored in
# aConstraint[].op using one of the SQLITE_INDEX_CONSTRAINT_ values.

R-30083-58938-31645-59750-38554-41419-43937-22175 tcl slt th3 src

The index of the column is stored in aConstraint[].iColumn.

/* IMP: R-30083-58938 */
# EVIDENCE-OF: R-30083-58938 The index of the column is stored in
# aConstraint[].iColumn.

R-00311-09993-39149-44899-64441-18371-52816-22132 tcl slt th3 src

aConstraint[].usable is TRUE if the expr on the right-hand side can be evaluated (and thus the constraint is usable) and false if it cannot.

/* IMP: R-00311-09993 */
# EVIDENCE-OF: R-00311-09993 aConstraint[].usable is TRUE if the expr on
# the right-hand side can be evaluated (and thus the constraint is
# usable) and false if it cannot.

R-34021-38482-31030-34652-01469-03047-61601-46080 tcl slt th3 src

The optimizer automatically inverts terms of the form "expr OP column" and makes other simplifications to the WHERE clause in an attempt to get as many WHERE clause terms into the form shown above as possible.

/* IMP: R-34021-38482 */
# EVIDENCE-OF: R-34021-38482 The optimizer automatically inverts terms
# of the form "expr OP column" and makes other simplifications to the
# WHERE clause in an attempt to get as many WHERE clause terms into the
# form shown above as possible.

R-41470-32236-05158-07794-46704-63040-13347-49238 tcl slt th3 src

The aConstraint[] array only reports WHERE clause terms that are relevant to the particular virtual table being queried.

/* IMP: R-41470-32236 */
# EVIDENCE-OF: R-41470-32236 The aConstraint[] array only reports WHERE
# clause terms that are relevant to the particular virtual table being
# queried.

R-04864-61029-16829-56446-03389-34714-38812-10063 tcl slt th3 src

Information about the ORDER BY clause is stored in aOrderBy[].

/* IMP: R-04864-61029 */
# EVIDENCE-OF: R-04864-61029 Information about the ORDER BY clause is
# stored in aOrderBy[].

R-42967-40755-03922-54202-06529-32553-15493-34553 tcl slt th3 src

Each term of aOrderBy records a column of the ORDER BY clause.

/* IMP: R-42967-40755 */
# EVIDENCE-OF: R-42967-40755 Each term of aOrderBy records a column of
# the ORDER BY clause.

R-22671-54036-59271-48827-17148-12128-60554-20551 tcl slt th3 src

If argvIndex>0 then the right-hand side of the corresponding aConstraint[] is evaluated and becomes the argvIndex-th entry in argv.

/* IMP: R-22671-54036 */
# EVIDENCE-OF: R-22671-54036 If argvIndex>0 then the right-hand side
# of the corresponding aConstraint[] is evaluated and becomes the
# argvIndex-th entry in argv.

R-43363-59092-12659-08651-39134-62372-15667-15588 tcl slt th3 src

If aConstraintUsage[].omit is true, then the constraint is assumed to be fully handled by the virtual table and might not be checked again by the byte code.

/* IMP: R-43363-59092 */
# EVIDENCE-OF: R-43363-59092 If aConstraintUsage[].omit is true, then
# the constraint is assumed to be fully handled by the virtual table and
# might not be checked again by the byte code.

R-27061-43436-37550-51046-04512-17816-21037-16098 tcl slt th3 src

The aConstraintUsage[].omit flag is an optimization hint. When the omit flag is left in its default setting of false, the constraint will always be checked separately in byte code. If the omit flag is change to true, then the constraint may or may not be checked in byte code. In other words, when the omit flag is true there is no guarantee that the constraint will not be checked again using byte code.

/* IMP: R-27061-43436 */
# EVIDENCE-OF: R-27061-43436 The aConstraintUsage[].omit flag is an
# optimization hint. When the omit flag is left in its default setting
# of false, the constraint will always be checked separately in byte
# code. If the omit flag is change to true, then the constraint may or
# may not be checked in byte code. In other words, when the omit flag is
# true there is no guarantee that the constraint will not be checked
# again using byte code.

R-31745-09510-54957-62702-22501-02582-05423-29843 tcl slt th3 src

The idxNum and idxStr values are recorded and passed into the xFilter method.

/* IMP: R-31745-09510 */
# EVIDENCE-OF: R-31745-09510 The idxNum and idxStr values are recorded
# and passed into the xFilter method.

R-10865-13181-22257-60026-20125-29584-36389-07390 tcl slt th3 src

sqlite3_free() is used to free idxStr if and only if needToFreeIdxStr is true.

/* IMP: R-10865-13181 */
# EVIDENCE-OF: R-10865-13181 sqlite3_free() is used to free idxStr if
# and only if needToFreeIdxStr is true.

R-22671-22821-00746-11610-44216-38779-63984-03906 tcl slt th3 src

The orderByConsumed means that output from xFilter/xNext will occur in the correct order to satisfy the ORDER BY clause so that no separate sorting step is required.

/* IMP: R-22671-22821 */
# EVIDENCE-OF: R-22671-22821 The orderByConsumed means that output from
# xFilter/xNext will occur in the correct order to satisfy the ORDER BY
# clause so that no separate sorting step is required.

R-65124-17715-29002-58648-01842-29148-18346-40549 tcl slt th3 src

The estimatedCost value is an estimate of the cost of a particular strategy.

/* IMP: R-65124-17715 */
# EVIDENCE-OF: R-65124-17715 The estimatedCost value is an estimate of
# the cost of a particular strategy.

R-24707-22256-10968-61514-58469-45624-50106-41306 tcl slt th3 src

The estimatedRows value is an estimate of the number of rows that will be returned by the strategy.

/* IMP: R-24707-22256 */
# EVIDENCE-OF: R-24707-22256 The estimatedRows value is an estimate of
# the number of rows that will be returned by the strategy.