diff options
| author | drh <drh@noemail.net> | 2016-02-25 18:40:18 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2016-02-25 18:40:18 +0000 |
| commit | eecb80e77e3556e9373237eff6ab0a8dad7eb5fb (patch) | |
| tree | 4d7fd5bda9743c6409dd8ba2d76e4bc8a96167ee /src/treeview.c | |
| parent | d8c22ac655458ce388fe7517e3ff472ce2daf603 (diff) | |
| parent | 5a6f5ede8175ff253b85925e2728ea76f8c86c9f (diff) | |
| download | sqlite-eecb80e77e3556e9373237eff6ab0a8dad7eb5fb.tar.gz sqlite-eecb80e77e3556e9373237eff6ab0a8dad7eb5fb.zip | |
Query planner improvements: Take the LIMIT into account when estimated the
cost of an ORDER BY. Avoid automatic indexes on query loops that are expected
to run less than twice.
FossilOrigin-Name: bf46179d4484376909dce40ffcc06fecb19b3544
Diffstat (limited to 'src/treeview.c')
| -rw-r--r-- | src/treeview.c | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/treeview.c b/src/treeview.c index 298580431..ff3b4be5a 100644 --- a/src/treeview.c +++ b/src/treeview.c @@ -132,9 +132,10 @@ void sqlite3TreeViewSelect(TreeView *pView, const Select *p, u8 moreToFollow){ sqlite3TreeViewPush(pView, 1); } do{ - sqlite3TreeViewLine(pView, "SELECT%s%s (0x%p) selFlags=0x%x", + sqlite3TreeViewLine(pView, "SELECT%s%s (0x%p) selFlags=0x%x nSelectRow=%d", ((p->selFlags & SF_Distinct) ? " DISTINCT" : ""), - ((p->selFlags & SF_Aggregate) ? " agg_flag" : ""), p, p->selFlags + ((p->selFlags & SF_Aggregate) ? " agg_flag" : ""), p, p->selFlags, + (int)p->nSelectRow ); if( cnt++ ) sqlite3TreeViewPop(pView); if( p->pPrior ){ |