Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA28966 for ; Tue, 21 Sep 1999 11:11:05 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA21909; Tue, 21 Sep 1999 11:10:30 -0400 (EDT) To: raptor cc: "'pgsql-sql@postgresql.org'" Subject: Re: [SQL] OID & indexes. In-reply-to: Your message of Tue, 21 Sep 1999 17:56:58 -0400 <37E7FF29.1BB059BC@unacs.bg> Date: Tue, 21 Sep 1999 11:10:30 -0400 Message-ID: <21907.937926630@sss.pgh.pa.us> From: Tom Lane raptor writes: > Is the OID fileld indexed and if not can I create index on it. No, and yes. OID is just like any regular column as far as indexing is concerned. You should make an index on it if you plan to do lots of 'WHERE oid = something' queries. regards, tom lane