-
are attributes that are indexed in tables also indexed in views?
-
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.
-
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?
-
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,12c
email: ocp_9i@yahoo.com
-
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.
-
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|