Lines Matching full:covering
2864 ** the use of covering indices for full table scans in the query optimizer.
2868 ** The ability to disable the use of covering indices for full table scans
15409 #define SQLITE_CoverIdxScan 0x0020 /* Covering index scans */
16057 unsigned isCovering:1; /* True if this is a covering index */
17154 int bUseCis; /* Use covering indices for full-scans */
97638 ** An index covering an expression means that the expression can be
99213 ** Note 1: In the special case of the covering index that implements a
99221 ** PRIMARY KEY of the table. The covering index that implements the
103304 ** so that the PRIMARY KEY is a covering index. The surplus
104856 ** it as a covering index */
109955 Index *pIdx, /* Index on parent covering the foreign key */
120298 assert( p->op!=TK_COLUMN || p->pTab!=0 ); /* Covering idx not yet coded */
123587 bCover ? " USING COVERING INDEX " : "",
128715 Index *pCovidx; /* Possible covering index for WHERE_MULTI_OR */
129344 zFmt = "AUTOMATIC PARTIAL COVERING INDEX";
129346 zFmt = "AUTOMATIC COVERING INDEX";
129348 zFmt = "COVERING INDEX %s";
130883 /* pIdx is a covering index. No need to access the main table. */
130980 Index *pCov = 0; /* Potential covering index (or NULL) */
131179 ** be possible to use that index as a covering index.
131184 ** terms, set pCov to the candidate covering index. Otherwise, set
131185 ** pCov to NULL to indicate that no candidate covering index will
133641 ** covering index. A "covering index" is an index that contains all
133642 ** columns that are needed by the query. With a covering index, the
133644 ** be a covering index because the index will not be updated if the
133686 ** a covering index */
134817 ** (5) If X is a covering index, than Y is too
134825 ** was added because a covering index probably deserves to have a lower cost
134826 ** than a non-covering index even if it is a proper subset.
135495 ** seek only. Then, if this is a non-covering index, add the cost of
135664 ** cost = nRow * K // scan of covering index
135665 ** cost = nRow * (K+3.0) // scan of non-covering index
135674 ** cost = nSeek * (log(nRow) + K * nVisit) // covering index
135675 ** cost = nSeek * (log(nRow) + (K+3.0) * nVisit) // non-covering index
135684 ** log(nRow) factor is omitted from a non-covering index scan in order to
135866 /* If this is a non-covering index scan, add in the cost of
143945 ** boolean in order to enable or disable the use of covering indices for
