Re: indexes and views

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Mar 2005 10:53:22 -0800
Message-ID: <1110480802.032544.321290@f14g2000cwb.googlegroups.com>

Actually the ability of Oracle to use an index to solve a query depends on the where clause conditions.

If the query against v1 included where v1.c1 = :varialbe [or constant] then Oracle would be able to use the index on c1 to solve the query if the CBO believes that is the best access path.

To rephrase what Sybrand said to you, all the indexes on the base tables of a view are potentially available for use by the CBO when the view is queried. What indexes may or may not be used depends on the view, the tables, the indexes, and the query submitted to Oracle.

HTH -- Mark D Powell -- Received on Thu Mar 10 2005 - 12:53:22 CST