Indices - Mailing list pgsql-sql

From Nikolaj Lundsgaard
Subject Indices
Date
Msg-id 001501c08206$57555a40$8fd426c0@commando.kampsax.dtu.dk
Whole thread Raw
List pgsql-sql
Maybe a wrong mailinglist to ask this, but...

Are there any plans on writing a chapter in the documentation about the implementation of indices. I know from M$ SQL
Serverthat it is no picnic determining which indices are useful, and thick books can be written on how to make the
rightindices for the right query. 
 

I have no idea if postgres has similar strange ways of using indices, but even so, that should be written in the
documentation.However I find it highly probable that I am not the only one having trouble designing indices. Often I
seequestions on this mailinglist sounding like: "Why is my query not using the index". These would perhaps be less
frequentin the future if such a chapter was written.
 


Have a nice week-end

Regards, Nikolaj



pgsql-sql by date:

Previous
From: "Sharmad Naik"
Date:
Subject: primary key and indexing
Next
From: "Aleksey V. Kurinov"
Date:
Subject: SELECT FROM SELECT