SQL tuning for a Z program

One SQL in the Z program is in the top SQL GET list.

The sql is:

SELECT /*+ FIRST_ROWS (1) */ "CONTENT" FROM "ZT1004" WHERE "MANDT" = :A0 AND "SURVEY_ID" = :A1 AND "QUES_ID" = :A2 AND "ORDER_GUID" = :A3 AND ROWNUM <= :A4

SQL> describe sapsr3.zt1004;

Name Null? Type

-

-

-

MANDT NOT NULL VARCHAR2(9)

INQUIRY_GUID NOT NULL RAW(16)

ORDER_GUID NOT NULL RAW(16)

SURVEY_ID NOT NULL VARCHAR2(30)

QUES_ID NOT NULL NUMBER(3)

CONTENT NOT NULL VARCHAR2(300)

Only UNIQUE index for this table:

SQL> select DBMS_METADATA.GET_DDL('INDEX','ZT1004~0','SAPSR3') from dual;

DBMS_METADATA.GET_DDL('INDEX','ZT1004~0','SAPSR3')

-

CREATE UNIQUE INDEX "SAPSR3"."ZT1004~0" ON "SAPSR3"."ZT1004" ("MANDT", "INQ

UIRY_GUID", "ORDER_GUID", "SURVEY_ID", "QUES_ID")

PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTI

CS

STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_P

OOL DEFAULT)

TABLESPACE "PSAPSR3"

Edited by: ren qc on Sep 15, 2010 4:31 AM