185   int i;  in openStatTable()  local
205   for(i=0; i<ArraySize(aTable); i++){  in openStatTable()
206     const char *zTab = aTable[i].zName;  in openStatTable()
208     aCreateTbl[i] = 0;  in openStatTable()
210       if( i<nToOpen ){  in openStatTable()
216             "CREATE TABLE %Q.%s(%s)", pDb->zDbSName, zTab, aTable[i].zCols  in openStatTable()
218         aRoot[i] = (u32)pParse->regRoot;  in openStatTable()
219         aCreateTbl[i] = OPFLAG_P2ISREG;  in openStatTable()
225       aRoot[i] = pStat->tnum;  in openStatTable()
226       sqlite3TableLock(pParse, iDb, aRoot[i], 1, zTab);  in openStatTable()
238         sqlite3VdbeAddOp2(v, OP_Clear, (int)aRoot[i], iDb);  in openStatTable()
244   for(i=0; i<nToOpen; i++){  in openStatTable()
245     assert( i<ArraySize(aTable) );  in openStatTable()
246     sqlite3VdbeAddOp4Int(v, OP_OpenWrite, iStatCur+i, (int)aRoot[i], iDb, 3);  in openStatTable()
247     sqlite3VdbeChangeP5(v, aCreateTbl[i]);  in openStatTable()
248     VdbeComment((v, aTable[i].zName));  in openStatTable()
369     int i;  in statAccumDestructor()  local
370     for(i=0; i<p->nCol; i++) sampleClear(p->db, p->aBest+i);  in statAccumDestructor()
371     for(i=0; i<p->mxSample; i++) sampleClear(p->db, p->a+i);  in statAccumDestructor()
456     int i;                          /* Used to iterate through p->aSample[] */  in statInit()  local
467     for(i=0; i<(mxSample+nCol); i++){  in statInit()
468       p->a[i].anEq = (tRowcnt *)pSpace; pSpace += (sizeof(tRowcnt) * nColUp);  in statInit()
469       p->a[i].anLt = (tRowcnt *)pSpace; pSpace += (sizeof(tRowcnt) * nColUp);  in statInit()
470       p->a[i].anDLt = (tRowcnt *)pSpace; pSpace += (sizeof(tRowcnt) * nColUp);  in statInit()
474     for(i=0; i<nCol; i++){  in statInit()
475       p->aBest[i].iCol = i;  in statInit()
516   int i;  in sampleIsBetterPost()  local
518   for(i=pNew->iCol+1; i<nCol; i++){  in sampleIsBetterPost()
519     if( pNew->anEq[i]>pOld->anEq[i] ) return 1;  in sampleIsBetterPost()
520     if( pNew->anEq[i]<pOld->anEq[i] ) return 0;  in sampleIsBetterPost()
559   int i;  in sampleInsert()  local
579     for(i=p->nSample-1; i>=0; i--){  in sampleInsert()
580       StatSample *pOld = &p->a[i];  in sampleInsert()
630     for(i=0; i<p->mxSample; i++){  in sampleInsert()
631       if( p->a[i].isPSample ) continue;  in sampleInsert()
632       if( iMin<0 || sampleIsBetter(p, &p->a[iMin], &p->a[i]) ){  in sampleInsert()
633         iMin = i;  in sampleInsert()
650   int i;  in samplePushPrevious()  local
654   for(i=(p->nCol-2); i>=iChng; i--){  in samplePushPrevious()
655     StatSample *pBest = &p->aBest[i];  in samplePushPrevious()
656     pBest->anEq[i] = p->current.anEq[i];  in samplePushPrevious()
658       sampleInsert(p, pBest, i);  in samplePushPrevious()
664   for(i=p->nSample-1; i>=0; i--){  in samplePushPrevious()
666     for(j=p->nMaxEqZero; j<p->nCol; j++) assert( p->a[i].anEq[j]>0 );  in samplePushPrevious()
671     for(i=p->nSample-1; i>=0; i--){  in samplePushPrevious()
674         if( p->a[i].anEq[j]==0 ) p->a[i].anEq[j] = p->current.anEq[j];  in samplePushPrevious()
706   int i;  in statPush()  local
719     for(i=0; i<p->nCol; i++) p->current.anEq[i] = 1;  in statPush()
728     for(i=0; i<iChng; i++){  in statPush()
729       p->current.anEq[i]++;  in statPush()
731     for(i=iChng; i<p->nCol; i++){  in statPush()
732       p->current.anDLt[i]++;  in statPush()
734       if( p->mxSample ) p->current.anLt[i] += p->current.anEq[i];  in statPush()
736       p->current.anEq[i] = 1;  in statPush()
762     for(i=0; i<(p->nCol-1); i++){  in statPush()
763       p->current.iCol = i;  in statPush()
764       if( i>=iChng || sampleIsBetterPost(p, &p->current, &p->aBest[i]) ){  in statPush()
765         sampleCopy(p, &p->aBest[i], &p->current);  in statPush()
860     int i;               /* Loop counter */  in statGet()  local
865     for(i=0; i<p->nKeyCol; i++){  in statGet()
866       u64 nDistinct = p->current.anDLt[i] + 1;  in statGet()
870       assert( p->current.anEq[i] );  in statGet()
892     int i;  in statGet()  local
905     for(i=0; i<p->nCol; i++){  in statGet()
906       sqlite3_str_appendf(&sStat, "%llu ", (u64)aCnt[i]);  in statGet()
950   int i;           /* Index of column in the table */  in analyzeVdbeCommentIndexWithColumnName()  local
952   i = pIdx->aiColumn[k];  in analyzeVdbeCommentIndexWithColumnName()
953   if( NEVER(i==XN_ROWID) ){  in analyzeVdbeCommentIndexWithColumnName()
955   }else if( i==XN_EXPR ){  in analyzeVdbeCommentIndexWithColumnName()
959     VdbeComment((v,"%s.%s", pIdx->zName, pIdx->pTable->aCol[i].zCnName));  in analyzeVdbeCommentIndexWithColumnName()
983   int i;                       /* Loop counter */  in analyzeOneTable()  local
1178       for(i=0; i<nColTest; i++){  in analyzeOneTable()
1179         char *pColl = (char*)sqlite3LocateCollSeq(pParse, pIdx->azColl[i]);  in analyzeOneTable()
1180         sqlite3VdbeAddOp2(v, OP_Integer, i, regChng);  in analyzeOneTable()
1181         sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, i, regTemp);  in analyzeOneTable()
1182         analyzeVdbeCommentIndexWithColumnName(v,pIdx,i);  in analyzeOneTable()
1183         aGotoChng[i] =   in analyzeOneTable()
1184         sqlite3VdbeAddOp4(v, OP_Ne, regTemp, 0, regPrev+i, pColl, P4_COLLSEQ);  in analyzeOneTable()
1200       for(i=0; i<nColTest; i++){  in analyzeOneTable()
1201         sqlite3VdbeJumpHere(v, aGotoChng[i]);  in analyzeOneTable()
1202         sqlite3VdbeAddOp3(v, OP_Column, iIdxCur, i, regPrev+i);  in analyzeOneTable()
1203         analyzeVdbeCommentIndexWithColumnName(v,pIdx,i);  in analyzeOneTable()
1290       for(i=0; i<nCol; i++){  in analyzeOneTable()
1291         sqlite3ExprCodeLoadIndexColumn(pParse, pIdx, iTabCur, i, regCol+i);  in analyzeOneTable()
1403   int i;  in sqlite3Analyze()  local
1420     for(i=0; i<db->nDb; i++){  in sqlite3Analyze()
1421       if( i==1 ) continue;  /* Do not analyze the TEMP database */  in sqlite3Analyze()
1422       analyzeDatabase(pParse, i);  in sqlite3Analyze()
1472   int i;  local
1480   for(i=0; *z && i<nOut; i++){
1487     if( aOut ) aOut[i] = v;
1488     if( aLog ) aLog[i] = sqlite3LogEst(v);
1493     aLog[i] = sqlite3LogEst(v);
1640       int i;                    /* Used to iterate through samples */  local
1661       for(i=0; i<nSample; i++){
1662         if( i==(pIdx->nSample-1)
1663          || aSample[i].anDLt[iCol]!=aSample[i+1].anDLt[iCol] 
1665           sumEq += aSample[i].anEq[iCol];
1736     int i;          /* Bytes of space required */  local
1764     for(i=0; i<nSample; i++){
1765       pIdx->aSample[i].anEq = pSpace; pSpace += nIdxCol;
1766       pIdx->aSample[i].anLt = pSpace; pSpace += nIdxCol;
1767       pIdx->aSample[i].anDLt = pSpace; pSpace += nIdxCol;
1869   HashElem *i;  local
1880   for(i=sqliteHashFirst(&pSchema->tblHash); i; i=sqliteHashNext(i)){
1881     Table *pTab = sqliteHashData(i);
1884   for(i=sqliteHashFirst(&pSchema->idxHash); i; i=sqliteHashNext(i)){
1885     Index *pIdx = sqliteHashData(i);
1911   for(i=sqliteHashFirst(&pSchema->idxHash); i; i=sqliteHashNext(i)){
1912     Index *pIdx = sqliteHashData(i);
1923   for(i=sqliteHashFirst(&pSchema->idxHash); i; i=sqliteHashNext(i)){
1924     Index *pIdx = sqliteHashData(i);