Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    Unanswered: Query Optimising

    Hi There,

    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 ;

  2. #2
    Join Date
    Jan 2003
    Location
    The Netherlands
    Posts
    149

    optimiser mode

    Hi there,

    I changed the optimiser mode and i can reduce the query within a second, but i used first_rows as mode. if there are more rows to be returned this is not good. anyone????

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •