I will be very happy with a tool(or a stats table) that shows the most searched values from a table(since a statistic reset). i.e.:
table foo (id int, year int)
top 3 searched value for year field: 2017(500x), 2016(300x), 2015(55x)
With this info we can create partial indexes or do a table partitioning.
2017-10-31 15:25 GMT-02:00 Neto pr <netopr9@xxxxxxxxx>:
Thanks for reply Antony.But from what I've read, HYPOPG only allows you to create hypothetical indexes, so the DBA can analyze if it brings benefits.What I would like is a tool that from a SQL Query indicates which indexes would be recommended to decrease the response time.Best RegardsNeto2017-10-31 15:19 GMT-02:00 Anthony Sotolongo <asotolongo@xxxxxxxxx>:El 31 oct. 2017 2:13 PM, "Neto pr" <netopr9@xxxxxxxxx> escribió:Hello All I'm researching on Index-Advisor Tools to be applied in SQL queries. At first I found this: - EnterpriseDB - https://www.enterprisedb.com/docs/en/9.5/asguide/EDB_Postgre Someone would know of other tools for this purpose. I'd appreciate it if you can help me.s_Advanced_Server_Guide.1.56.h tml Best RegardsNeto
