Re: [GENERAL] oid and index

At 17:53 +0300 on 17/06/1999, Jonathan Davis wrote:

>
> one question
>
> what's the difference between oid and index ?

An oid is a unique number given automatically to every object in a
PostgreSQL database, such as a row or a large object.

An index is a method of accelerating access to the database when the query
is done on specific fields. If the fields are indexed, SELECT operations
using them will generally be faster, but INSERT and UPDATE may be slightly
slower.

There is really no connection between an oid and an index, except for the
fact that you can create an index on the oid attribute of a table, and thus
accelerate retrieval of rows by their oids.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma