| From: | Edoardo Ceccarelli <eddy(at)axa(dot)it> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org |
| Subject: | is a good practice to create an index on the oid? |
| Date: | 2004-04-26 16:38:00 |
| Message-ID: | 408D3AE8.5020006@axa.it |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-jdbc pgsql-performance |
I am using the oid of the table as the main key and I've found that is
not indexed (maybe because I have declared another primary key in the table)
it is a good practice to create an index like this on the oid of a table?
CREATE INDEX idoid annuncio400 USING btree (oid);
does it work as a normal index?
Thank you
Edoardo
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Garry | 2004-04-26 22:45:08 | Re: How configure Oracle 9i not case sensitive... |
| Previous Message | Ross Ferris | 2004-04-24 15:32:38 | Re: How configure Oracle 9i not case sensitive... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2004-04-26 16:38:59 | Re: How do handle concurrent DML operations |
| Previous Message | David Wall | 2004-04-26 15:54:29 | Re: BLOBS |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | brad-pgperf | 2004-04-26 17:11:03 | planner/optimizer question |
| Previous Message | Sailesh Krishnamurthy | 2004-04-26 15:08:16 | Re: Number of pages in a random sample |