Never ending query

[falconace]

Ok, I have a query that when run, runs forever and never returns values. Any ideas?

Select Distinct WORK_CENTER.SITE, SFC.STATUS_BO
  From WORK_CENTER, SFC_STEP, SFC
 Where WORK_CENTER.SITE = 'TEST'
  And Parse_Handle(SFC_STEP.REPORTING_CENTER_BO,2) = 'TEST'

[gamyers]

Don't run the query ?

Seriously, you need to understand the concept of joins.
You have no link between SFC_STEP and SFC. Maybe SFC_STEPs have an SFC_ID that says they relate to a particular row in the SFC table. You may know that, but you haven't 'told' that query to use that relationship.

[marist89]

What's it waiting on?

What's the plan?

http://marist89.blogspot.com/2005/07/trace-it_04.html

[tamilselvan]

No join between tables ??

Try FIRST_ROWS hint, and see you get rows.

Tamil

[malay_biswal]

Oh boy, you are screwing the query royally. Use the joins as mentioned by gamyers.