Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: query performance

Re: query performance

From: Jim Poe <jpoe_at_fulcrumit.com>
Date: 11 Oct 2001 18:57:25 GMT
Message-ID: <9q4q2l$q5k@dispatch.concentric.net>


tkprof results

TEST



SELECT DISTINCT SUBM_QUOTE_SRCH.SUBM_ID, SUBM_QUOTE_SRCH.PDCR_NAME,

  SUBM_QUOTE_SRCH.INSD_NAME,  SUBM_QUOTE_SRCH.INSD_PRIMARY_CITY,
  SUBM_QUOTE_SRCH.INSD_PRIMARY_ST,  SUBM_QUOTE_SRCH.SUBM_ENTRY_DT,
  SUBM_QUOTE_SRCH.SUBM_SCHED_DT

FROM
  SUBM_QUOTE_SRCH WHERE ( UPPER( SUBM_QUOTE_SRCH.INSD_NAME_SRCH ) LIKE '%' )

      ORDER BY SUBM_QUOTE_SRCH.SUBM_ID call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ------



Parse 1 0.00 0.00 0 3451 0 0
Execute 1 0.00 0.00 0 0 0 0
Fetch 1 0.00 0.00 0 48129 5616 19
------- ------ -------- ---------- ---------- ---------- ---------- ------

total 3 0.00 0.00 0 51580 5616 19

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 19



DEVL



SELECT DISTINCT SUBM_QUOTE_SRCH.SUBM_ID, SUBM_QUOTE_SRCH.PDCR_NAME,

  SUBM_QUOTE_SRCH.INSD_NAME,  SUBM_QUOTE_SRCH.INSD_PRIMARY_CITY,
  SUBM_QUOTE_SRCH.INSD_PRIMARY_ST,  SUBM_QUOTE_SRCH.SUBM_ENTRY_DT,
  SUBM_QUOTE_SRCH.SUBM_SCHED_DT

FROM
  SUBM_QUOTE_SRCH WHERE ( UPPER( SUBM_QUOTE_SRCH.INSD_NAME_SRCH ) LIKE '%' )

      ORDER BY SUBM_QUOTE_SRCH.SUBM_ID call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ------



Parse 2 0.00 0.00 0 2042 23 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 0.00 0.00 0 3688 6008 40
------- ------ -------- ---------- ---------- ---------- ---------- ------

total 6 0.00 0.00 0 5730 6031 40

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 19



Thanks for any help.

--
Jim Poe (jpoe_at_fulcrumit.com)
Received on Thu Oct 11 2001 - 13:57:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US