Обсуждение: Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)

Поиск
Список
Период
Сортировка

Re: [NOVICE] Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)

От
Josh Berkus
Дата:
Michael,

> My final thought would be to continue using "functional index", noting
> that operators are a special class of function. Out of the above
> description of "value expression", I believe only functions and
> operators are allowed as expressions in the CREATE INDEX syntax,
> correct? (Besides referring to a column.)

Well argued.  The problem is Peter's point, which you weren't cc'd on:

>At least it's better than "functional index", because I had always
>wondered where the dysfunctional indexes went. :)


--
-Josh BerkusAglio Database SolutionsSan Francisco