> > >> > >> 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.} > > > You can index directly on a view too -- it's like indexing on a cursor, a > temp index is created... like I said, as far as I know.... -- 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...