Received: from bologna.nettuno.it (bologna.nettuno.it [193.43.2.1]) by hub.org (8.9.3/8.9.3) with ESMTP id IAA47044 for ; Wed, 22 Sep 1999 08:28:24 -0400 (EDT) (envelope-from jose@sferacarta.com) Received: from proxy.sferacarta.com (mail@sfcabop1.nettuno.it [193.207.10.213]) by bologna.nettuno.it (8.9.3/8.9.3/NETTuno 3.3) with ESMTP id OAA09977; Wed, 22 Sep 1999 14:28:12 +0200 (MDT) Received: from rosso.sferacarta.com (sferacarta.com) [10.20.30.5] by proxy.sferacarta.com with esmtp (Exim 2.05 #1 (Debian)) id 11TnHq-0005Ff-00; Wed, 22 Sep 1999 14:22:22 +0000 Message-ID: <37E8CBDE.B87F1653@sferacarta.com> Date: Wed, 22 Sep 1999 14:30:22 +0200 From: =?iso-8859-1?Q?Jos=E9?= Soares X-Mailer: Mozilla 4.5 [it] (Win95; I) X-Accept-Language: it MIME-Version: 1.0 To: raptor CC: "'pgsql-sql@postgresql.org'" Subject: Re: [SQL] OID & indexes. References: <37E7FF29.1BB059BC@unacs.bg> Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit raptor ha scritto: > hi, > > Is the OID fileld indexed and if not can I create index on it. > The OID field is not indexed by default but you can create an index on it as: create index idx_name on table_name (oid); José