Subject | Optimal plans using views |
---|---|
Author | kokok_kokok |
Post date | 2008-06-11T15:34:37Z |
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
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