Thread

1. select * from table where oid = number;

   Taral <taral@mail.utexas.edu> — 1998-10-08T19:48:08Z

   Is there a reason why this occurs?
   
   table=> explain select * from data where oid = 18522;
   NOTICE:  QUERY PLAN:
   
   Seq Scan on data  (cost=0.00 size=0 width=120)
   
   EXPLAIN
   
   I would have expected an index scan or something.
   
   TAral
   
   

2. Re: [GENERAL] select * from table where oid = number;

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-10-08T21:40:53Z

   [Charset iso-8859-1 unsupported, filtering to ASCII...]
   > Is there a reason why this occurs?
   > 
   > table=> explain select * from data where oid = 18522;
   > NOTICE:  QUERY PLAN:
   > 
   > Seq Scan on data  (cost=0.00 size=0 width=120)
   > 
   > EXPLAIN
   > 
   > I would have expected an index scan or something.
   
   See FAQ.  oid's are not automatically indexed.
   
   -- 
     Bruce Momjian                        |  http://www.op.net/~candle
     maillist@candle.pha.pa.us            |  (610) 853-3000
     +  If your life is a hard drive,     |  830 Blythe Avenue
     +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026