Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    36

    Unanswered: Performance related

    I have a qry which returns 15000 rows that qry has got union operator it is taking 12 to 14 seconds for retrieving the data.. i think it is long time..
    can i optimize the qry to make it faster .. if so what should i do to optimize it...i already used the hint in the qry to optimize it... any other alternative is there to best optimize the qry..

    Thank U

    bujji

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Performance related

    Originally posted by vadlamanibujji
    I have a qry which returns 15000 rows that qry has got union operator it is taking 12 to 14 seconds for retrieving the data.. i think it is long time..
    can i optimize the qry to make it faster .. if so what should i do to optimize it...i already used the hint in the qry to optimize it... any other alternative is there to best optimize the qry..

    Thank U

    bujji
    Impossible to say without knowing the query, table structures, indexes, data volumes, ...

Posting Permissions

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