Home
last modified time | relevance | path

Searched refs:Index (Results 1 – 25 of 40) sorted by relevance

12

/sqlite-3.40.0/test/
H A Dfts3f.test52 1 {Index optimized} 2 {Index already optimal} 3 {Index already optimal}
53 4 {Index already optimal}
54 5 {Index already optimal} 6 {Index already optimal}
H A Dminmax3.test63 # Index optimizes the WHERE x='2' constraint.
68 # Index optimizes the WHERE x='2' constraint and the MAX(y).
73 # Index optimizes the WHERE x='2' constraint and the MAX(y).
93 # Index i1 optimizes the WHERE x='2' constraint.
98 # Index i2 optimizes the WHERE x='2' constraint and the min(y).
103 # Index optimizes the WHERE x='2' constraint and the MAX(y).
114 # Index i1 optimizes the min(y)
119 # Index i1 optimizes the min(y)
130 # Index i1 optimizes the max(y)
135 # Index i1 optimizes the max(y)
H A Dfts2q.test301 } {{Index optimized} 1 0}
335 } {{Index already optimal} 1 0}
344 } {{Index already optimal} 2 0}
H A Dfts3d.test262 } {{Index optimized} 1 0}
296 } {{Index already optimal} 1 0}
306 } {{Index already optimal} 2 0}
H A De_fts3.test518 # the returned value should be "Index optimized" if the data structure
519 # was modified, or "Index already optimal" if it were not.
531 } {{Index optimized}}
534 } {{Index already optimal}}
H A Dfts3fault.test97 faultsim_test_result {0 {{Index optimized}}}
/sqlite-3.40.0/src/
H A Danalyze.c1406 Index *pIdx; in sqlite3Analyze()
1538 Index *pIndex;
1582 Index fakeIdx;
1599 void sqlite3DeleteIndexSamples(sqlite3 *db, Index *pIdx){
1624 static void initAvgEq(Index *pIdx){
1683 static Index *findIndexOrPrimaryKey(
1688 Index *pIdx = sqlite3FindIndex(db, zName, zDb);
1733 Index *pIdx; /* Pointer to the index object */
1885 Index *pIdx = sqliteHashData(i);
1912 Index *pIdx = sqliteHashData(i);
[all …]
H A Dbuild.c541 Index *p = 0; in sqlite3FindIndex()
581 Index *pIndex; in sqlite3UnlinkAndDeleteIndex()
591 Index *p; in sqlite3UnlinkAndDeleteIndex()
1081 Index *p; in sqlite3PrimaryKeyIndex()
1619 Index *pIdx; in sqlite3AddNotNull()
1955 Index *pIdx; in sqlite3AddCollateType()
2336 Index *pIdx; in convertToWithoutRowidTable()
2337 Index *pPk; in convertToWithoutRowidTable()
3299 Index *pIdx; in destroyTable()
4299 Index *pIdx; in sqlite3CreateIndex()
[all …]
H A DsqliteInt.h1191 typedef struct Index Index; typedef
2607 struct Index { struct
4600 int sqlite3IndexHasDuplicateRootPage(Index*);
4622 Index *sqlite3PrimaryKeyIndex(Table*);
4623 i16 sqlite3TableColumnToIndex(Index*, i16);
4689 void sqlite3FreeIndex(sqlite3*, Index*);
4826 int sqlite3GenerateIndexKey(Parse*, Index*, int, int, int, int*,Index*,int);
5112 void sqlite3DeleteIndexSamples(sqlite3*,Index*);
5113 void sqlite3DefaultRowEst(Index*);
5122 KeyInfo *sqlite3KeyInfoOfIndex(Parse*, Index*);
[all …]
H A Ddelete.c225 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3LimitWhere()
288 Index *pIdx; /* For looping over indices of the table */ in sqlite3DeleteFrom()
302 Index *pPk; /* The PRIMARY KEY index on the table */ in sqlite3DeleteFrom()
896 Index *pIdx; /* Current index */ in sqlite3GenerateRowIndexDelete()
897 Index *pPrior = 0; /* Prior index */ in sqlite3GenerateRowIndexDelete()
899 Index *pPk; /* PRIMARY KEY index, or NULL for rowid tables */ in sqlite3GenerateRowIndexDelete()
952 Index *pIdx, /* The index for which to generate a key */ in sqlite3GenerateIndexKey()
957 Index *pPrior, /* Previously generated index key */ in sqlite3GenerateIndexKey()
H A Dupsert.c98 Index *pIdx; /* One of the indexes of pTab */ in sqlite3UpsertAnalyzeTarget()
234 Upsert *sqlite3UpsertOfIndex(Upsert *pUpsert, Index *pIdx){ in sqlite3UpsertOfIndex()
258 Index *pIdx, /* The UNIQUE constraint that failed */ in sqlite3UpsertDoUpdate()
281 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3UpsertDoUpdate()
H A Dfkey.c187 Index **ppIdx, /* OUT: Unique index on parent table */ in sqlite3FkLocateIndex()
190 Index *pIdx = 0; /* Value to return via *ppIdx */ in sqlite3FkLocateIndex()
324 Index *pIdx, /* Unique index on parent key columns in pTab */ in fkLookupParent()
551 Index *pIdx, /* Index on parent covering the foreign key */ in fkScanChildren()
915 Index *pIdx = 0; /* Index on key columns in pTo */ in sqlite3FkCheck()
1017 Index *pIdx = 0; /* Foreign key index for pFKey */ in sqlite3FkCheck()
1102 Index *pIdx = 0; in sqlite3FkOldmask()
1228 Index *pIdx = 0; /* Parent key index for this FK */ in fkActionTrigger()
H A Dinsert.c44 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3OpenTable()
73 const char *sqlite3IndexAffinityStr(sqlite3 *db, Index *pIdx){ in sqlite3IndexAffinityStr()
237 Index *pIndex; in readsTable()
1529 Index *pIdx; /* The current Index */
1542 Index *p; /* The index */
1547 static Index *indexIteratorFirst(IndexIterator *pIter, int *pIx){ in indexIteratorFirst()
1559 static Index *indexIteratorNext(IndexIterator *pIter, int *pIx){ in indexIteratorNext()
1682 Index *pIdx; /* Pointer to one of the indices */ in sqlite3GenerateConstraintChecks()
2564 Index *pIdx; /* An index being inserted or updated */ in sqlite3CompleteInsertion()
2653 Index *pIdx; in sqlite3OpenTableAndIndices()
[all …]
H A Dwhere.c594 Index *pIdx; in isDistinctRedundant()
1120 Index *pIdx = pLoop->u.btree.pIndex; in sqlite3ConstructBloomFilter()
1696 Index *p = pLoop->u.btree.pIndex; in whereRangeSkipScanEst()
1813 Index *p = pLoop->u.btree.pIndex; in whereRangeScanEst()
2584 Index *pIndex = p->u.btree.pIndex; in whereLoopInsert()
3187 Index *pIndex, in indexMightHelpWithOrderBy()
3254 Index *pIdx; /* The index */
3413 memset(&sPk, 0, sizeof(Index)); in whereLoopAddBtree()
5187 Index *pIdx; in whereShortCut()
6287 Index *pIdx; in sqlite3WhereEnd()
[all …]
H A DwhereInt.h105 Index *pCoveringIdx; /* Possible covering index for WHERE_MULTI_OR */
145 Index *pIndex; /* Index used, or NULL */
513 Index *pIdx /* Must be compatible with this index, if not NULL */
H A Dwherecode.c28 static const char *explainIndexColumnName(Index *pIdx, int i){ in explainIndexColumnName()
45 Index *pIdx, /* Index to read column names from */ in explainAppendTerm()
88 Index *pIndex = pLoop->u.btree.pIndex; in explainIndexRange()
155 Index *pIdx; in sqlite3WhereExplainOneScan()
917 Index *pIdx; /* The index used to access the table */
1150 Index *pIdx, /* Index scan is using */ in codeDeferredSeek()
2036 Index *pPk = sqlite3PrimaryKeyIndex(pIdx->pTable); in sqlite3WhereCodeOneLoopStart()
2190 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3WhereCodeOneLoopStart()
2303 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3WhereCodeOneLoopStart()
2601 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3WhereCodeOneLoopStart()
[all …]
H A Dupdate.c98 Index *pIdx, /* The index to check */ in indexColumnIsBeingUpdated()
128 Index *pIdx, /* The index to check */ in indexWhereClauseMightChange()
190 Index *pPk, /* PK if table 0 is WITHOUT ROWID */ in updateFromSelect()
299 Index *pIdx; /* For looping over indices */ in sqlite3Update()
300 Index *pPk; /* The PRIMARY KEY index for WITHOUT ROWID tables */ in sqlite3Update()
1218 Index *pPk = 0; in updateVirtualTable()
1282 Index *pPk; /* PRIMARY KEY index */ in updateVirtualTable()
H A Dpragma.c1174 Index *pPk = sqlite3PrimaryKeyIndex(pTab); in sqlite3Pragma()
1298 Index *pIdx; in sqlite3Pragma()
1324 Index *pIdx; in sqlite3Pragma()
1369 Index *pIdx; in sqlite3Pragma()
1499 Index *pIdx; /* Index in the parent table */ in sqlite3Pragma()
1707 Index *pIdx; /* An index on pTab */ in sqlite3Pragma()
1722 Index *pIdx; in sqlite3Pragma()
1750 Index *pIdx, *pPk; in sqlite3Pragma()
1751 Index *pPrior = 0; /* Previous index */ in sqlite3Pragma()
2333 Index *pIdx; /* An index of the table */ in sqlite3Pragma()
H A Dvdbevtab.c223 Index *pIdx = (Index*)sqliteHashData(k); in bytecodevtabColumn()
H A Dprepare.c61 int sqlite3IndexHasDuplicateRootPage(Index *pIndex){ in sqlite3IndexHasDuplicateRootPage()
62 Index *p; in sqlite3IndexHasDuplicateRootPage()
172 Index *pIndex; in sqlite3InitCallback()
H A Dvdbe.h243 void sqlite3VdbeSetP4KeyInfo(Parse*, Index*);
H A Dvdbemem.c1378 Index *pIdx;
1400 Index *pIdx = p->pIdx; /* Index being probed */ in valueNew()
1815 Index *pIdx, /* Index being probed */ in sqlite3Stat4ProbeSetValue()
H A DvdbeInt.h518 Index *pPk; /* PK index if pTab is WITHOUT ROWID */
H A Dvdbeblob.c209 Index *pIdx; in sqlite3_blob_open()
/sqlite-3.40.0/ext/rtree/
H A DREADME115 [1] Atonin Guttman, "R-trees - A Dynamic Index Structure For Spatial

12