SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index a table for view

630050Jan 20 2011 — edited Jan 20 2011

Hi All,
Could anyone please tell if it is wise to create an index on a table just beause of a view. Suppose I have a table table1 and created view VIEW1 on this table as below:

create view VIEW1 as select * from table1 where column1='DATA'

Is is wise to create index on table1 (column1) just beause it's used in the view.

Thanks,
PS

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2011

Added on Jan 20 2011

3 comments

121 views