view's
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: view's

  1. #1
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    are attributes that are indexed in tables also indexed in views?

  2. #2
    Join Date
    Mar 2001
    Posts
    16
    Views contain no data. So there is nothing to index. If the select statement is written properly to use indexes on the underlying tables it will execute faster. Or an index may need to be created on underlying table.

  3. #3
    Join Date
    Feb 2001
    Location
    Master Control
    Posts
    86
    right i understand that, maybe i did not phrase my question correctly. say i have a table with an attribute called ID and i create a view that has ID in it. if i write and say view.ID = othertable.ID will this use the index on the underlying table?

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by bmullin
    Views contain no data. So there is nothing to index.
    True. However, in 9i you may have 3 types of constraints on views: PKs, UKs and FKs.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  5. #5
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    For Julian :

    Hi,

    Can u refer me some material for new features relating to SQL/PLSQL in 9i.
    eg : views , new clauses , syntax , etc .

    Take Care.

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    Thanks.

    Great work by TIM

    Take Care.

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