| Subject | Re: [ib-support] can i create index on view ? ...And How ? |
|---|---|
| Author | Claudio Valderrama C. |
| Post date | 2002-02-12T06:23:45Z |
""ysjhala"" <ysjhala@...> wrote in message
news:a4a6nq+dlg0@......
You CAN'T create an index on a view. You create the indices on the
underlying table(s) that make up the view.
C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing
news:a4a6nq+dlg0@......
> Dear Friends,Views are virtual tables only.
>
> Hi .. i have problem i want to create index on view but it give
> me error
You CAN'T create an index on a view. You create the indices on the
underlying table(s) that make up the view.
C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing