Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle table view and index
dobest wrote:
> When I make a view that is a indexed table, does that view affect index
> table ?
Only to the extent that you have a simple view and you do updates through it. Keep in mind that when you look at a view you have just executed the SELECT statement that defines the view. To the extent that the stored query can use indexes to speed execution it will. But you will only affect the index itself if you do inserts or updates that affect indexed columns.
Allan Received on Sat Aug 01 1998 - 17:13:43 CDT