Given a query, how do you know which indices to add? Given a query, how do you know which indices to add? database database

Given a query, how do you know which indices to add?


database postgresql database-indexes

You need data in tables.

Then you may use EXPLAIN ANALYZE

http://www.postgresql.org/docs/9.0/interactive/using-explain.html

You may add and drop indexes and compare times.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last