-
Sql Tuning
could someone please help me tune this sql, it kept running out of space on TEMP
SELECT ME.STREET, MO.STREET
FROM MAP ME, COUNTY LCM, MAP MO
WHERE ME.FEATURE = LCM.id AND LCM.CITY = MO.FEATURE
AND ME.num = '1' AND MO.num = '1'
MINUS
SELECT active_STREET, related_STREET FROM FEATURE_DATA;
thanks
-
Add more TEMP space.
Pipe it through Lecco for a re-write.
Buy Lecco.
MH
I remember when this place was cool.
-
lecco?????
what's that????
Any advises???
-
Start on Autotrace and send us the execution plan of your query.
In addition,check out if your columns in the "where" close are indexed.
Regards,
Nir
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
|