indexes - Mailing list pgsql-general

From Chethana, Rao (IE10)
Subject indexes
Date
Msg-id 544485BC51F81A41AC1A72CFA6901365724155@AZ18EV805.global.ds.honeywell.com
Whole thread Raw
Responses Re: indexes  (Martijn van Oosterhout <kleptog@svana.org>)
List 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 ?

 

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Temporal Databases, offtopic - relative updates
Next
From: Martijn van Oosterhout
Date:
Subject: Re: indexes