Hi, I was reading about indexes and I have a question:
is possible to use "hash" like index method in primary key constraints??
thanks
2011/7/20 Raghavendra :
>
> On Wed, Jul 20, 2011 at 2:39 PM, Vlastimil Krejcir
> wrote:
>>
>> Hi,
>>
>> what index is used (and according to what rules) when
On Wed, Jul 20, 2011 at 2:39 PM, Vlastimil Krejcir wrote:
> Hi,
>
> what index is used (and according to what rules) when there are two (or
> more) different indexes defined on one column? Assume:
>
> CREATE TABLE example (
> id SERIAL PRIMARY KEY,
> ...);
> CREATE INDEX example_id_idx ON exampl
Hi,
what index is used (and according to what rules) when there are two (or
more) different indexes defined on one column? Assume:
CREATE TABLE example (
id SERIAL PRIMARY KEY,
...);
CREATE INDEX example_id_idx ON example USING hash (id);
By default there are btree index created and the h
