what is the cpu utilization on your box?
Waleed
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 4/17/02 12:43 AM
Qs Why is elapsed Time so HIGH in the following SELECT ?
NOTE -
1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE
Table
2) The
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:High elapsed time when running on a Unique Index ??
Qs Why is elapsed Time so HIGH in the following SELECT ?
NOTE -
1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE
Table
2
Qs Why is elapsed Time so HIGH in the following SELECT ?
NOTE -
1) TBA_GENERAL_ACCT_MAST_TBL is a SYNONYM for GENERAL_ACCT_MAST_TABLE Table
2) The Respective Tablespace Contains ONLY ONE (i.e. This) Object
(GENERAL_ACCT_MAST_TABLE)
3) There is a UNIQUE Index on the field of the Where