Re: Can we add syntax for references auto create index or not.

On Tue, May 26, 2015 at 7:03 PM, digoal zhou <digoal(dot)zhou(at)gmail(dot)com> wrote:

> When we create table, some column use foreign key references.
> Now PostgreSQL don't create index for the FK, and there is no problem.
> But when some body need the index to speed up the query within these APP,
> they need to add the index manual one-by-one when has many tables.
> If we can add syntax for auto create index for FK by user's choose, and
> default not create?
>

​I presume you mean to modify the CREATE TABLE statement.​

​How does this help solve the problem "when some body need the index to
speed up the query"?

My first impression is that I like the idea. The fact that it is not
supported by the SQL standard is a drawback Do any other vendors do this?

David J.​