subject:"\[sqlite\] \[EXTERNAL\] virtual tables, and theTrue meaning of pIdxInfo\->estimatedCost, pIdxInfo\->estimatedRows, and pIdxInfo\->idxFlags..."

Re: [sqlite] [EXTERNAL] virtual tables, and theTrue meaning of pIdxInfo->estimatedCost, pIdxInfo->estimatedRows, and pIdxInfo->idxFlags...

2017-10-19 Thread Hick Gunter

I can provide some info coming from our experience with SQLite 3.7.14: Since most SQl processing is IO bound, the "estimated cost" should be the number of disk IO operations required to retrieve the rows. The later addition of "estimated rows" reflects to the fact that some virtual table implem

Re: [sqlite] [EXTERNAL] virtual tables, and theTrue meaning of pIdxInfo->estimatedCost, pIdxInfo->estimatedRows, and pIdxInfo->idxFlags...

2017-10-20 Thread dave

> Behalf Of Hick Gunter > Sent: Friday, October 20, 2017 1:55 AM > > I can provide some info coming from our experience with SQLite 3.7.14: > > Since most SQl processing is IO bound, the "estimated cost" > should be the number of disk IO operations required to > retrieve the rows. The later addi