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 ?