I use Postgres as my Database.As part of my project I am trying to Index adviser for Postgres which suggests indexes automatically to the queries running slow .
As far as I know only "EDB" has done it.(What I have done)Now, I am trying to create virtual indexes on the columns present in the query condition and if that index makes the query to run fast,I will suggest those indexes to the user. But, I don't know how that index will be useful in the future. Is my approach correct?? If not..please provide me with steps I need to follow inorder to do an "Index Adviser" for the queries...If u know..also provide how actually "EDB"(Enterprise DB) does the Index Adviser in their product "SQL Profiler"