Re: [PERFORM] Does it matters the column order in indexes and constraints

Arnau wrote: Hi all, I've got a doubt about how to create an index and a primary key. Lets say I have the following table: The country_id column can have maybe 100 - 250 different values. The customer_id column can have as much several hundred values (less than 1000). The telephone

[PERFORM] Does it matters the column order in indexes and constraints creation?

Hi all, I've got a doubt about how to create an index and a primary key. Lets say I have the following table: CREATE TABLE blacklist ( telephoneVARCHAR(15), customer_idINT4 CONSTRAINT fk_blacklist_customerid REFERENCES customers( custom