Re: Performance problem: anything else I can do to make this faster?

sconover_at_gmail.com wrote:

> Dan - which index did I miss?
>
> -Steve

My copy of SQL*Plus can't connect to your instance.

So how can I possibly know what indexes, of what index types, with what column orders exist? And then we can discuss cardinality, and whether your statistics are current and collected with DBMS_STATS.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)