| From: | pocm(at)rnl(dot)ist(dot)utl(dot)pt (Paulo J(dot) Matos) |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Index Management |
| Date: | 2002-01-31 01:24:53 |
| Message-ID: | 87d6zr1fdm.fsf@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hi all,
I've been creating indeces for my tables but I'm a bit lost
now. I'd like to know how indeces are managed? Are them
autommaticly chosen for a particular query? We choose the good
ones (maybe through a sql command)?
If I create 10 indeces and then I make some queries, how will
postgres manage the indeces and how to work through the queries?
Best regards,
--
Paulo J. Matos : pocm(_at_)rnl.ist.utl.pt
Instituto Superior Tecnico - Lisbon
Software & Computer Engineering - A.I.
- > http://www.rnl.ist.utl.pt/~pocm
---
Yes, God had a deadline...
So, He wrote it all in Lisp!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yan Bai | 2002-01-31 07:34:40 | How to merge several attributes and Delete an attribute |
| Previous Message | Josh Berkus | 2002-01-31 00:57:53 | Re: Difference between Access97 and PostgreSQL |