On Fri, 1 Mar 2013 09:29:55 -0400, W O <sistemas2000profesional@...>
wrote:

> The view V_ABM_PERSONAS is:
>
> CREATE VIEW V_ABM_PERSONAS(
> PER_IDENTI,

...

> FROM
> PERSONAS P

...

> ORDER BY
> P.PER_CEDULA;
>
> There is an index on the column PER_CEDULA and all the tables are using

its

> Primary Key or an Unique Key.
>
> CREATE INDEX IDX_PERSONAS1 ON PERSONAS(PER_CEDULA);

What happens when you remove the ORDER BY from the view definition? In
general I'd advise against specifying ORDER BY in a view.

Mark