Re: High CPU Query

Kumar wrote:
> Hi,
>
> Following query is talking high CPU, using Oracle9i on windows:

Try selecting the relevant records from hrm_curr_career_v and then join them to hrm_employee.

But I have a feeling hrm_curr_career_v is a view ... you might want to look at querying the underlying table(s) directly.

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