Skip to Content
Mar 09, 2009 at 10:11 AM

Secondary Indexes of the database table while fetching data fom the view


Hi All,

I have a database table ZZZ which has 10 fields. This database table has one secondary index on 3 fields.

I also have another database table YYY which has 20 fields, This database table has 2 secondary indexes on some of the fields.

I have a VIEW defined on the above two tables.

Now, when I write a select statement on the view, I need following clarifications

1) Is the index of the corresponding database table considered when retrieving data from the view

2) If the index is considered, then what are the rules used for them. i.e. which database table index will be hit first.