Lines Matching refs:Index
9305 typedef struct Index Index; typedef
10000 SQLITE_PRIVATE void sqlite3VdbeSetP4KeyInfo(Parse*, Index*);
11508 Index *pIndex; /* List of SQL indexes on this table. */
11731 struct Index { struct
11737 Index *pNext; /* The next index associated with the same table */ argument
12169 Index *pIndex; /* Index structure corresponding to zIndex, if any */
13123 SQLITE_PRIVATE Index *sqlite3PrimaryKeyIndex(Table*);
13124 SQLITE_PRIVATE i16 sqlite3ColumnOfIndex(Index*, i16);
13194 SQLITE_PRIVATE Index *sqlite3AllocateIndexObject(sqlite3*,i16,int,char**);
13195 SQLITE_PRIVATE Index *sqlite3CreateIndex(Parse*,Token*,Token*,SrcList*,ExprList*,int,Token*,
13242 SQLITE_PRIVATE Index *sqlite3FindIndex(sqlite3*,const char*, const char*);
13276 SQLITE_PRIVATE int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int, int*,Index*,int);
13286 SQLITE_PRIVATE void sqlite3UniqueConstraint(Parse*, int, Index*);
13405 SQLITE_PRIVATE const char *sqlite3IndexAffinityStr(Vdbe *, Index *);
13489 SQLITE_PRIVATE void sqlite3DeleteIndexSamples(sqlite3*,Index*);
13490 SQLITE_PRIVATE void sqlite3DefaultRowEst(Index*);
13500 SQLITE_PRIVATE KeyInfo *sqlite3KeyInfoOfIndex(Parse*, Index*);
13526 SQLITE_PRIVATE int sqlite3Stat4ProbeSetValue(Parse*,Index*,UnpackedRecord**,Expr*,u8,int,int*);
13640 SQLITE_PRIVATE int sqlite3FkLocateIndex(Parse*,Table*,FKey*,Index**,int**);
53227 Index *pIdx = (Index *)sqliteHashData(p);
64167 Index *pIdx;
64189 Index *pIdx = p->pIdx; /* Index being probed */
64636 Index *pIdx, /* Index being probed */
65650 SQLITE_PRIVATE void sqlite3VdbeSetP4KeyInfo(Parse *pParse, Index *pIdx){
77651 Index *pIdx;
84532 Index *pIdx; /* Iterator variable */
89019 Index *pOnlyIdx, /* If not NULL, only analyze this one index */
89025 Index *pIdx; /* An index to being analyzed */
89245 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
89380 static void analyzeTable(Parse *pParse, Table *pTab, Index *pOnlyIdx){
89417 Index *pIdx;
89491 Index *pIndex /* Handle extra flags for this index, if not NULL */
89559 Index *pIndex;
89599 Index fakeIdx;
89615 SQLITE_PRIVATE void sqlite3DeleteIndexSamples(sqlite3 *db, Index *pIdx){
89640 static void initAvgEq(Index *pIdx){
89699 static Index *findIndexOrPrimaryKey(
89704 Index *pIdx = sqlite3FindIndex(db, zName, zDb);
89735 Index *pPrevIdx = 0; /* Previous index in the loop */
89751 Index *pIdx; /* Pointer to the index object */
89805 Index *pIdx; /* Pointer to the index object */
89905 Index *pIdx = sqliteHashData(i);
89940 Index *pIdx = sqliteHashData(i);
91215 SQLITE_PRIVATE Index *sqlite3FindIndex(sqlite3 *db, const char *zName, const char *zDb){
91216 Index *p = 0;
91235 static void freeIndex(sqlite3 *db, Index *p){
91255 Index *pIndex;
91265 Index *p;
91398 Index *pIndex, *pNext;
91419 TESTONLY ( Index *pOld = ) sqlite3HashInsert(
91605 SQLITE_PRIVATE Index *sqlite3PrimaryKeyIndex(Table *pTab){
91606 Index *p;
91615 SQLITE_PRIVATE i16 sqlite3ColumnOfIndex(Index *pIdx, i16 iCol){
92132 Index *p;
92189 Index *pIdx;
92394 static int resizeIndexObject(sqlite3 *db, Index *pIdx, int N){
92432 static void estimateIndexWidth(Index *pIdx){
92475 Index *pIdx;
92476 Index *pPk;
92621 Index *pIdx; /* An implied index of the table */
93052 Index *pIdx = sqliteHashData(pElem);
93096 Index *pIdx;
93123 Index *pIdx;
93503 static void sqlite3RefillIndex(Parse *pParse, Index *pIndex, int memRootPage){
93590 SQLITE_PRIVATE Index *sqlite3AllocateIndexObject(
93596 Index *p; /* Allocated index object */
93599 nByte = ROUND8(sizeof(Index)) + /* Index structure */
93606 char *pExtra = ((char*)p)+ROUND8(sizeof(Index));
93634 SQLITE_PRIVATE Index *sqlite3CreateIndex(
93646 Index *pRet = 0; /* Pointer to return */
93648 Index *pIndex = 0; /* The index to be created */
93663 Index *pPk = 0; /* PRIMARY KEY index for WITHOUT ROWID tables */
93785 Index *pLoop;
93958 Index *pIdx;
94001 Index *p;
94094 Index *pOther = pTab->pIndex;
94133 SQLITE_PRIVATE void sqlite3DefaultRowEst(Index *pIdx){
94162 Index *pIndex;
94823 Index *pIdx /* The index that triggers the constraint */
94873 static int collationMatch(const char *zColl, Index *pIndex){
94893 Index *pIndex; /* An index associated with pTab */
94948 Index *pIndex; /* An index associated with pTab */
95007 SQLITE_PRIVATE KeyInfo *sqlite3KeyInfoOfIndex(Parse *pParse, Index *pIdx){
95811 Index *pIdx; /* For looping over indices of the table */
95825 Index *pPk; /* The PRIMARY KEY index on the table */
96312 Index *pIdx; /* Current index */
96313 Index *pPrior = 0; /* Prior index */
96315 Index *pPk; /* PRIMARY KEY index, or NULL for rowid tables */
96366 Index *pIdx, /* The index for which to generate a key */
96371 Index *pPrior, /* Previously generated index key */
98414 Index **ppIdx, /* OUT: Unique index on parent table */
98417 Index *pIdx = 0; /* Value to return via *ppIdx */
98549 Index *pIdx, /* Unique index on parent key columns in pTab */
98768 Index *pIdx, /* Index on parent covering the foreign key */
98838 Index *pPk = sqlite3PrimaryKeyIndex(pTab);
99105 Index *pIdx = 0; /* Index on key columns in pTo */
99204 Index *pIdx = 0; /* Foreign key index for pFKey */
99289 Index *pIdx = 0;
99392 Index *pIdx = 0; /* Parent key index for this FK */
99673 Index *pPk = sqlite3PrimaryKeyIndex(pTab);
99702 SQLITE_PRIVATE const char *sqlite3IndexAffinityStr(Vdbe *v, Index *pIdx){
99797 Index *pIndex;
100082 Index *pIdx; /* For looping over indices of the table */
100773 Index *pIdx; /* Pointer to one of the indices */
100774 Index *pPk = 0; /* The PRIMARY KEY index */
101181 Index *pIdx; /* An index being inserted or updated */
101265 Index *pIdx;
101341 static int xferCompatibleIndex(Index *pDest, Index *pSrc){
101405 Index *pSrcIdx, *pDestIdx; /* Source and destination indices */
104605 Index *pPk = sqlite3PrimaryKeyIndex(pTab);
104646 Index *pIdx;
104678 Index *pIdx;
104725 Index *pIdx;
104841 Index *pIdx; /* Index in the parent table */
105054 Index *pIdx;
105086 Index *pIdx, *pPk;
105087 Index *pPrior = 0;
105682 Index *pIndex;
110281 Index *pIdx;
111141 Index *pIdx /* Index used to optimize scan, or NULL */
111822 Index *pIdx; /* Iterator variable */
111824 Index *pBest = 0; /* Best index found so far */
113499 Index *pIdx; /* For looping over indices */
113500 Index *pPk; /* The PRIMARY KEY index for WITHOUT ROWID tables */
115807 Index *pCovidx; /* Possible covering index for WHERE_MULTI_OR */
115844 Index *pIndex; /* Index used, or NULL */
116708 Index *pIdx /* Must be compatible with this index */
116763 Index *pIdx /* Must be compatible with this index, if not NULL */
117697 Index *pIdx, /* Index to match column of */
117733 Index *pIdx;
117878 Index *pIdx; /* Object describing the transient index */
118217 Index *pIdx, /* Index to consider domain of */
118462 Index *p = pLoop->u.btree.pIndex;
118580 Index *p = pLoop->u.btree.pIndex;
118752 Index *p = pBuilder->pNew->u.btree.pIndex;
118817 Index *p = pBuilder->pNew->u.btree.pIndex;
119084 Index *pIdx; /* The index being used for this loop */
119208 Index *pIndex = pLoop->u.btree.pIndex;
119293 Index *pIdx;
119701 Index *pIdx; /* The index we will be using */
119893 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable);
119969 Index *pCov = 0; /* Potential covering index (or NULL) */
120030 Index *pPk = sqlite3PrimaryKeyIndex(pTab);
120113 Index *pPk = sqlite3PrimaryKeyIndex(pTab);
120760 Index *pIndex = p->u.btree.pIndex;
120867 Index *pProbe, /* An index on pSrc */
121145 Index *pIndex,
121170 static Bitmask columnsInIndex(Index *pIdx){
121242 Index *pProbe; /* An index we are evaluating */
121243 Index sPk; /* A fake index object for the primary key */
121275 Index *pFirst; /* First of real indices on the table */
121276 memset(&sPk, 0, sizeof(Index));
121808 Index *pIndex; /* The index associated with pLoop */
122467 Index *pIdx;
122950 Index *pIx = pLoop->u.btree.pIndex;
122963 Index *pJ = pTabItem->pTab->pIndex;
123130 Index *pIdx = 0;
123207 Index *pPk = sqlite3PrimaryKeyIndex(pTab);
