-
Never ending query
Ok, I have a query that when run, runs forever and never returns values. Any ideas?
Code:
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.
Tamil
-
Oh boy, you are screwing the query royally. Use the joins as mentioned by gamyers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|