1 Reply Latest reply: Jul 11, 2005 12:40 AM by JustinCave RSS

    How to create index on view

    191363
      Can I create an index on a view?I heard oralce has support this feature.
        • 1. Re: How to create index on view
          JustinCave
          A view is just a stored query, so it contains no data to index. Indexes would have to be created on the base table.

          If your view were a materialized view, since the materialized view contains a copy of the data, you could create an index on it.

          Justin
          Distributed Database Consulting, Inc.
          http://www.ddbcinc.com/askDDBC