On Tuesday 2002-02-12 at 04:46:50 -0000, ysjhala wrote:

> Dear Friends,
>
> Hi .. i have problem i want to create index on view but it give
> me error
>
> "Unsuccessful metadata update attempt to index a view
> Statement: create index pro_productname on productnamehelp
> (Productname)"
>
> so is there any solution for it.

You can't index views. Perhaps you want different views with different
ORDER BY clauses?

David Trudgett