>
> Can I create and use an index on a local view? If so, how?
Not as far as I know.
What you can do, if you need to seek or use other index functions is to
SELECT * FROM myview INTO TABLE myviewcdx.
INDEX ON {index expression, etc.}
--
Matt McDonnell
Conventional Wisdom - "If it ain't broke, don't fix it."
Gates Wisdom - "If it doesn't work, sell it, and fix it later."
Matt McDonnell
...building a better mousetrap with moldy cheese...