indexes

From: "Chethana, Rao (IE10)" <Chethana(dot)Rao(at)Honeywell(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: indexes
Date: 2006-02-28 14:56:14
Message-ID: 544485BC51F81A41AC1A72CFA6901365724155@AZ18EV805.global.ds.honeywell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

i tried creating indexes on columns that have datatype as bigint or
smallint , but when I performed explain analyze, the query was using
sequential scan

instead of index scanning.

Is it not possible to create indexes for attributes whose datatypes r
bigint or smallint ?

Responses

  • Re: indexes at 2006-02-28 14:59:54 from Martijn van Oosterhout

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-02-28 14:59:54 Re: indexes
Previous Message Christopher Browne 2006-02-28 13:22:58 Re: Temporal Databases, offtopic - relative updates