Indexes on Materialized Views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Indexes on Materialized Views

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577

    Indexes on Materialized Views

    Hi,

    We have implemented snapshot replication to make our internal data available to clients.

    Do we need to create indexes on materialized views or oracle automatically used the indexes on the master tables. The materialized views are exactly sale as the master tables.. even their names.

    For example

    create materialized view company build immediate
    as select * from company@dblink;

    Please suggest.

    Thanks
    Ron
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    select index_name from user_indexes;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width