Re: [JDBC] is a good practice to create an index on the oid?

Yes, you can create an index on the oid, but unless you are selecting on
it, it is of little use.

you would have to do select * from foo where oid=? to get any value out
of the index.

Dave
On Mon, 2004-04-26 at 12:38, Edoardo Ceccarelli wrote:
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 
> 
> 
> !DSPAM:408d7c38183971270217895!
> 
> 
-- 
Dave Cramer
519 939 0336
ICQ # 14675561