Index use on views

Hi all,
I have a view that selects the WHOLE data from several tables but grouping the data in a special way. This way, whenever I query this view a FULL TABLE SCAN is executed.

One of the underlying tables has an index on the column REGION_ID, and whenever I query this table using WHERE REGION_ID = X this index is used and I get a very fast response.

My Question is:
If I query THE VIEW using the same predicate (WHERE REGION_ID = X), will my query use an index on this column instead of executing a Full Table Scan? Or will ANY QUERIES on this view execute a FULL TABLE SCAN ?

FYI, I am using Oracle 9i.

Many thanks in advance,
Ana Received on Thu Jan 25 2007 - 11:47:08 CST