Subject Re: [firebird-support] Rename table
Author Milan Babuskov
Sándor Tamás wrote:
> Is there any possibility, that I have created view on a table with some 'where' condition, and it slows SPs so much, with the original table, and where clauese I get some 10 secs, but with view, with the same clauses (of course without the table filtering) I got 2-3 minutes, or maybe 10-20 minutes.

There is, esp. if you use Firebird 1.0. You can easilt check by looking
at the query plan.

> Can I do aníthing with this?

- if you use FB 1.0, switch to 1.5
- use tables instead of views
- make stored procedures to optimize complex queries

Milan Babuskov