Try to take into account the cost of inner loops when selecting which table
of a join to use for the outer loop.
FossilOrigin-Name: 942556342a332b04a11169bb04f387d741ef9488
diff --git a/src/sqliteInt.h b/src/sqliteInt.h
index e44ce7b..eb77925 100644
--- a/src/sqliteInt.h
+++ b/src/sqliteInt.h
@@ -1967,6 +1967,7 @@
} in; /* Used when plan.wsFlags&WHERE_IN_ABLE */
Index *pCovidx; /* Possible covering index for WHERE_MULTI_OR */
} u;
+ double rOptCost; /* "Optimal" cost for this level */
/* The following field is really not part of the current level. But
** we need a place to cache virtual table index information for each