Does anybody else think it would be cool if you could use a shorthand
expression for creating an index on a foreign key? I think it's fair
to say that in the majority of cases, if you're using a foreign key,
you're going to want an index on it.
I know that it was decided a fair few releases ago to stop creating an
implicit index for each foreign key, and that's cool, but should the
creation syntax really require a separate statement for every single
FK you want to index?
Something like ...
CREATE TABLE foo (
foo int NOT NULL REFERENCES bar INDEX
);
... would be marvellous
My apologies if this has been answered before, but a search of the
-general mailing list was not fruitful.
BJ