Never ending query
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'
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.
No join between tables ??
Try FIRST_ROWS hint, and see you get rows.
Oh boy, you are screwing the query royally. Use the joins as mentioned by gamyers.
Click Here to Expand Forum to Full Width