Questions tagged as 'vistas-materializadas'

Query. The following is a query that uses three tables: (Everything from here on is anonymous, some involuntary error can slip) SELECT id ,id_dependencia ,descripcion_corta NOMBRE ,to_char(fecha_fallecimiento, 'YYYY-MM-DD') FE...

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'...