Subject Optimal plans using views
Author kokok_kokok
I have found that FB 2.0 does not get a good plan when I use some
views. It does not use index in some scenarios, just natural queries.

Then, if I rewrite the SQL using the underlying view sql statement, FB
get the optimal plan. It seems than the View "hides" the index in some
scenarios.

Does somebody have a similar problem?

Thank you