Index Struct Reference

Data Fields
char *	zName
i16 *	aiColumn
LogEst *	aiRowLogEst
Table *	pTable
char *	zColAff
Index *	pNext
Schema *	pSchema
u8 *	aSortOrder
const char **	azColl
Expr *	pPartIdxWhere
ExprList *	aColExpr
Pgno	tnum
LogEst	szIdxRow
u16	nKeyCol
u16	nColumn
u8	onError
unsigned	idxType:2
unsigned	bUnordered:1
unsigned	uniqNotNull:1
unsigned	isResized:1
unsigned	isCovering:1
unsigned	noSkipScan:1
unsigned	hasStat1:1
unsigned	bNoQuery:1
unsigned	bAscKeyBug:1
unsigned	bHasVCol:1
Bitmask	colNotIdxed

Detailed Description

Definition at line 17776 of file sqlite3.c.

Field Documentation

aColExpr

ExprList* Index::aColExpr

Definition at line 17787 of file sqlite3.c.

Referenced by exprMightBeIndexed2(), indexColumnIsBeingUpdated(), indexMightHelpWithOrderBy(), renameColumnFunc(), sqlite3CreateIndex(), sqlite3GenerateConstraintChecks(), sqlite3IndexAffinityStr(), sqlite3UpsertAnalyzeTarget(), whereIndexExprTrans(), wherePathSatisfiesOrderBy(), whereScanInit(), and xferCompatibleIndex().

aiColumn

i16* Index::aiColumn

Definition at line 17778 of file sqlite3.c.

Referenced by analyzeOneTable(), codeAllEqualityTerms(), codeDeferredSeek(), collationMatch(), constructAutomaticIndex(), convertToWithoutRowidTable(), explainIndexColumnName(), exprMightBeIndexed2(), findIndexCol(), fkActionTrigger(), fkLookupParent(), fkScanChildren(), indexColumnIsBeingUpdated(), indexMightHelpWithOrderBy(), isDupColumn(), recomputeColumnsNotIndexed(), sqlite3AddNotNull(), sqlite3AllocateIndexObject(), sqlite3CreateIndex(), sqlite3DeleteFrom(), sqlite3FindInIndex(), sqlite3FkCheck(), sqlite3FkLocateIndex(), sqlite3FkOldmask(), sqlite3GenerateConstraintChecks(), sqlite3GenerateIndexKey(), sqlite3IndexAffinityStr(), sqlite3Pragma(), sqlite3TableColumnToIndex(), sqlite3Update(), sqlite3UpsertAnalyzeTarget(), sqlite3UpsertDoUpdate(), sqlite3WhereBegin(), sqlite3WhereEnd(), updateFromSelect(), updateVirtualTable(), whereIndexExprTrans(), whereLoopAddBtree(), whereLoopAddBtreeIndex(), wherePathSatisfiesOrderBy(), whereRangeVectorLen(), whereScanInit(), and xferCompatibleIndex().

aiRowLogEst

LogEst* Index::aiRowLogEst

Definition at line 17779 of file sqlite3.c.

Referenced by analysisLoader(), sqlite3AllocateIndexObject(), sqlite3CreateIndex(), sqlite3DefaultRowEst(), sqlite3Pragma(), sqlite3WhereEnd(), whereLoopAddBtree(), and whereLoopAddBtreeIndex().

aSortOrder

u8* Index::aSortOrder

Definition at line 17784 of file sqlite3.c.

Referenced by codeEqualityTerm(), convertToWithoutRowidTable(), sqlite3AllocateIndexObject(), sqlite3CreateIndex(), sqlite3FindInIndex(), sqlite3KeyInfoOfIndex(), sqlite3Pragma(), wherePathSatisfiesOrderBy(), whereRangeScanEst(), whereRangeVectorLen(), and xferCompatibleIndex().

azColl

const char** Index::azColl

Definition at line 17785 of file sqlite3.c.

Referenced by analyzeOneTable(), collationMatch(), constructAutomaticIndex(), convertToWithoutRowidTable(), findIndexCol(), isDupColumn(), sqlite3AllocateIndexObject(), sqlite3CreateIndex(), sqlite3FindInIndex(), sqlite3FkLocateIndex(), sqlite3GenerateConstraintChecks(), sqlite3KeyInfoOfIndex(), sqlite3Pragma(), sqlite3UpsertAnalyzeTarget(), wherePathSatisfiesOrderBy(), whereRangeVectorLen(), whereScanInit(), xferCompatibleIndex(), and xferOptimization().

bAscKeyBug

unsigned Index::bAscKeyBug

Definition at line 17801 of file sqlite3.c.

Referenced by convertToWithoutRowidTable(), and sqlite3RefillIndex().

bHasVCol

unsigned Index::bHasVCol

Definition at line 17802 of file sqlite3.c.

Referenced by sqlite3CreateIndex(), and whereIndexExprTrans().

bNoQuery

unsigned Index::bNoQuery

Definition at line 17800 of file sqlite3.c.

Referenced by sqlite3KeyInfoOfIndex(), and whereLoopAddBtree().

bUnordered

unsigned Index::bUnordered

Definition at line 17794 of file sqlite3.c.

Referenced by analysisLoader(), decodeIntArray(), indexMightHelpWithOrderBy(), sqlite3Select(), whereLoopAddBtree(), whereLoopAddBtreeIndex(), and wherePathSatisfiesOrderBy().

colNotIdxed

Bitmask Index::colNotIdxed

Definition at line 17811 of file sqlite3.c.

Referenced by recomputeColumnsNotIndexed(), whereLoopAddBtree(), and whereShortCut().

hasStat1

unsigned Index::hasStat1

Definition at line 17799 of file sqlite3.c.

Referenced by analysisLoader(), sqlite3AnalysisLoad(), sqlite3DefaultRowEst(), sqlite3Pragma(), and whereLoopAddBtreeIndex().

idxType

unsigned Index::idxType

Definition at line 17793 of file sqlite3.c.

Referenced by deleteTable(), isDupColumn(), sqlite3CreateIndex(), sqlite3GenerateConstraintChecks(), sqlite3Pragma(), whereLoopAddBtree(), whereLoopInsert(), and xferOptimization().

isCovering

unsigned Index::isCovering

Definition at line 17797 of file sqlite3.c.

Referenced by convertToWithoutRowidTable(), sqlite3CreateIndex(), whereLoopAddBtree(), and whereShortCut().

isResized

unsigned Index::isResized

Definition at line 17796 of file sqlite3.c.

nColumn

u16 Index::nColumn

Definition at line 17791 of file sqlite3.c.

Referenced by analyzeOneTable(), codeDeferredSeek(), collationMatch(), convertToWithoutRowidTable(), isDupColumn(), recomputeColumnsNotIndexed(), sqlite3AllocateIndexObject(), sqlite3CompleteInsertion(), sqlite3CreateIndex(), sqlite3FindInIndex(), sqlite3GenerateConstraintChecks(), sqlite3GenerateIndexKey(), sqlite3GenerateRowIndexDelete(), sqlite3IndexAffinityStr(), sqlite3Insert(), sqlite3KeyInfoOfIndex(), sqlite3Pragma(), sqlite3TableColumnToIndex(), sqlite3Update(), sqlite3WhereBegin(), valueNew(), whereIndexExprTrans(), whereLoopAddBtree(), whereLoopAddBtreeIndex(), wherePathSatisfiesOrderBy(), whereRangeVectorLen(), xferCompatibleIndex(), and xferOptimization().

nKeyCol

u16 Index::nKeyCol

Definition at line 17790 of file sqlite3.c.

Referenced by analysisLoader(), analyzeOneTable(), convertToWithoutRowidTable(), exprMightBeIndexed2(), fkScanChildren(), indexMightHelpWithOrderBy(), isDistinctRedundant(), isDupColumn(), sqlite3AddNotNull(), sqlite3AllocateIndexObject(), sqlite3CompleteInsertion(), sqlite3CreateIndex(), sqlite3DefaultRowEst(), sqlite3DeleteFrom(), sqlite3FindInIndex(), sqlite3FkLocateIndex(), sqlite3FkOldmask(), sqlite3GenerateConstraintChecks(), sqlite3GenerateIndexKey(), sqlite3GenerateRowIndexDelete(), sqlite3KeyInfoOfIndex(), sqlite3Pragma(), sqlite3RefillIndex(), sqlite3Update(), sqlite3UpsertAnalyzeTarget(), sqlite3UpsertDoUpdate(), updateFromSelect(), updateVirtualTable(), whereLoopAddBtree(), whereLoopAddBtreeIndex(), wherePathSatisfiesOrderBy(), whereShortCut(), and xferCompatibleIndex().

noSkipScan

unsigned Index::noSkipScan

Definition at line 17798 of file sqlite3.c.

Referenced by decodeIntArray(), and whereLoopAddBtreeIndex().

onError

u8 Index::onError

Definition at line 17792 of file sqlite3.c.

Referenced by sqlite3AddNotNull(), sqlite3CompleteInsertion(), sqlite3CreateIndex(), sqlite3GenerateConstraintChecks(), sqlite3Update(), whereLoopAddBtree(), whereLoopAddBtreeIndex(), and xferCompatibleIndex().

pNext

Index* Index::pNext

Definition at line 17782 of file sqlite3.c.

Referenced by analyzeOneTable(), convertToWithoutRowidTable(), deleteTable(), destroyTable(), exprMightBeIndexed2(), isDistinctRedundant(), readsTable(), reindexTable(), renameColumnFunc(), sqlite3_declare_vtab(), sqlite3AddNotNull(), sqlite3CompleteInsertion(), sqlite3CreateIndex(), sqlite3DeleteFrom(), sqlite3EndTable(), sqlite3FindInIndex(), sqlite3FkLocateIndex(), sqlite3GenerateConstraintChecks(), sqlite3GenerateRowIndexDelete(), sqlite3IndexedByLookup(), sqlite3IndexHasDuplicateRootPage(), sqlite3Insert(), sqlite3OpenTableAndIndices(), sqlite3Pragma(), sqlite3Select(), sqlite3UnlinkAndDeleteIndex(), sqlite3Update(), sqlite3UpsertAnalyzeTarget(), sqlite3WhereBegin(), whereLoopAddBtree(), whereShortCut(), and xferOptimization().

pPartIdxWhere

Expr* Index::pPartIdxWhere

Definition at line 17786 of file sqlite3.c.

Referenced by analysisLoader(), analyzeOneTable(), indexWhereClauseMightChange(), renameColumnFunc(), renameTableFunc(), sqlite3CompleteInsertion(), sqlite3CreateIndex(), sqlite3DefaultRowEst(), sqlite3FindInIndex(), sqlite3FkLocateIndex(), sqlite3GenerateConstraintChecks(), sqlite3GenerateIndexKey(), sqlite3Pragma(), sqlite3Select(), sqlite3UpsertAnalyzeTarget(), whereLoopAddBtree(), whereShortCut(), and xferCompatibleIndex().

pSchema

Schema* Index::pSchema

Definition at line 17783 of file sqlite3.c.

Referenced by analyzeOneTable(), deleteTable(), destroyTable(), sqlite3CreateIndex(), sqlite3DeleteFrom(), sqlite3OpenTableAndIndices(), sqlite3Pragma(), sqlite3RefillIndex(), and sqlite3WhereBegin().

pTable

Table* Index::pTable

Definition at line 17780 of file sqlite3.c.

Referenced by analysisLoader(), analyzeOneTable(), codeDeferredSeek(), constructAutomaticIndex(), decodeIntArray(), explainIndexColumnName(), fkLookupParent(), fkScanChildren(), isDupColumn(), recomputeColumnsNotIndexed(), sqlite3_declare_vtab(), sqlite3Analyze(), sqlite3CreateIndex(), sqlite3DefaultRowEst(), sqlite3GenerateConstraintChecks(), sqlite3GenerateIndexKey(), sqlite3IndexAffinityStr(), sqlite3IndexHasDuplicateRootPage(), sqlite3Pragma(), sqlite3RefillIndex(), sqlite3UnlinkAndDeleteIndex(), sqlite3WhereEnd(), whereIndexExprTrans(), whereLoopAddBtree(), whereLoopAddBtreeIndex(), wherePathSatisfiesOrderBy(), whereRangeVectorLen(), whereScanInit(), and xferCompatibleIndex().

szIdxRow

LogEst Index::szIdxRow

Definition at line 17789 of file sqlite3.c.

Referenced by analysisLoader(), decodeIntArray(), sqlite3Pragma(), sqlite3Select(), whereLoopAddBtree(), and whereLoopAddBtreeIndex().

tnum

Pgno Index::tnum

Definition at line 17788 of file sqlite3.c.

Referenced by analyzeOneTable(), convertToWithoutRowidTable(), destroyTable(), fkLookupParent(), readsTable(), sqlite3CreateIndex(), sqlite3DeleteFrom(), sqlite3FindInIndex(), sqlite3IndexHasDuplicateRootPage(), sqlite3InitCallback(), sqlite3OpenTable(), sqlite3OpenTableAndIndices(), sqlite3Pragma(), sqlite3RefillIndex(), sqlite3RootPageMoved(), sqlite3Select(), sqlite3WhereBegin(), and xferOptimization().

uniqNotNull

unsigned Index::uniqNotNull

Definition at line 17795 of file sqlite3.c.

Referenced by analyzeOneTable(), convertToWithoutRowidTable(), sqlite3AddNotNull(), sqlite3CompleteInsertion(), sqlite3CreateIndex(), sqlite3GenerateIndexKey(), sqlite3GenerateRowIndexDelete(), sqlite3KeyInfoOfIndex(), whereLoopAddBtreeIndex(), and whereShortCut().

zColAff

char* Index::zColAff

Definition at line 17781 of file sqlite3.c.

Referenced by sqlite3IndexAffinityStr().

zName

char* Index::zName

Definition at line 17777 of file sqlite3.c.

Referenced by analyzeOneTable(), analyzeTable(), codeAllEqualityTerms(), constructAutomaticIndex(), deleteTable(), explainSimpleCount(), renameTableFunc(), sqlite3CreateIndex(), sqlite3FindInIndex(), sqlite3GenerateConstraintChecks(), sqlite3GenerateRowIndexDelete(), sqlite3IndexedByLookup(), sqlite3OpenTableAndIndices(), sqlite3Pragma(), sqlite3RefillIndex(), sqlite3UpsertDoUpdate(), sqlite3WhereBegin(), sqlite3WhereEnd(), sqlite3WhereExplainOneScan(), whereLoopAddBtreeIndex(), xferOptimization(), and yy_reduce().

---

The documentation for this struct was generated from the following file:

• sqlite3.c