Firebird materialized views

Question

Firebird materialized views

Navigation

#1 by (0 votes)

0

Good afternoon colleagues, I'm trying to improve the performance of a database in Firebird 1.5; I've noticed that the consultations I do on some views take too long, and I read there is a way to materialize the view to improve performance.

I've been looking for it, but I'm not sure how it works.

firebird 1.5 has that option ?, or in what version is this implemented?

thank you very much

sql vistas-materializadas firebird

asked by alejoecheverri444 20.10.2017 в 22:15

source

1 answer

Foreach does not stop problem with liquid-slider in IE

score 0 · Answer 1

This materialized view does not sound like anything to me. To optimize the view you have to put filters to the call, where, and ensure that the filtered fields are indexed. If you put the query that you make when calling the view, you may see the problem better.