Re: SQL Performance Problem

crs_stat wrote:

> I just can't seem to understand why Oracle chose to access
> the table via xif26NC_PARAMS when the XIF12 index was far superior.

Jonathan Lewis offers a seminar that addresses precisely this question. Basically ... it is because based on the information Oracle as available to it ... it disagrees with your assessment. I don't see a version in this post but my generic advice would be to help Oracle understand by giving it better, more accurate, information.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)