I have the following query. It takes 9 secs! i have read some oracle-pdf's about query optimising but they are not very specific. also tried sqlab under toad. can anyone give me a hint(no word joke).
SELECT tc.COLUMN_NAME, tc.DATA_TYPE domain_id,
DECODE(tc.DATA_TYPE, 'NUMBER', tc.DATA_PRECISION,
tc.DATA_LENGTH) width, d.sfieinput,d.sfieprotected
FROM DBA_CONS_COLUMNS child, DBA_CONSTRAINTS cc,
DBA_TAB_COLUMNS tc, ish.sfield d
WHERE child.OWNER = 'ISH' AND child.TABLE_NAME = 'BUILDINGPART' AND cc.OWNER = 'ISH' AND cc.CONSTRAINT_NAME= child.CONSTRAINT_NAME AND cc.TABLE_NAME = 'BUILDINGPART' AND cc.CONSTRAINT_TYPE = 'P' AND tc.OWNER = 'ISH' AND tc.TABLE_NAME = 'BUILDINGPART' AND tc.COLUMN_NAME = child.COLUMN_NAME AND d.sfiedbd = 'UMM' AND d.sfierec = 'BUILDINGPART' AND d.sfiename = tc.COLUMN_NAME ;