Tag Info

New answers tagged

3

This Script contain few columns 1. UserSeek : Number of seeks by user queries 2. UserScans: Number of scans by user queries 3. UserLookups: Number of bookmark lookups by user queries 4. UserUpdates: Number of updates by user queries on the basis these column stats you can figure out either index is useful or not. Actually Index are ...


1

No. How would the query processor recognize that it should use the materialized view. The materialized view is another object. See http://www.postgresql.org/docs/9.4/static/rules-materializedviews.html In part that explains: "When a materialized view is referenced in a query, the data is returned directly from the materialized view." So materialized ...



Top 50 recent answers are included