The system can’t know what conditions will be present when your query executes
sometime in the future without defining those conditions. To define those
conditions you create a simulated environment with the index, data, and load
you want to test and test it.
Without more info, your requiremen
> On Feb 26, 2015, at 12:47 AM, Sreerama Manoj
> wrote:
>
> Hi,
> I use Postgres 9.4 database.Now,I am optimizing the queries by using the
> results of "explain" and "explain analyze",Sometimes I am creating Indexes to
> optimize them. But, I was not successful sometimes as even I create
