SQL Data Extraction for CLOB [message #675165] |
Wed, 13 March 2019 02:02 |
|
rahul1982
Messages: 53 Registered: November 2011 Location: Pune
|
Member |
|
|
Hello,
I'm executing select statement on below table that has 4 CLOB column. SQL takes time to pull all the records, there are around 50 K records. I tried adding parallel hint but it has not improved the extraction.
Below is the explain plan. Please suggest how SQL extraction can be improved.
EXPLAIN PLAN FOR
SELECT ACCOUNT_ID,
ACCOUNT_RECORD_TYPE,
STG_ELM_CASE.DESCRIPTION,--CLOB
ACTIONS_TAKEN_COMMENT,--CLOB
ADDITIONAL_NOTES,--CLOB
BASE_MODULES--CLOB
ENGAGED_SME_CSM
FROM
case_desc;
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------
Plan hash value: 1938165839
----------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
----------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 58828 | 92M| 4407 (1)| 00:00:01 |
| 1 | TABLE ACCESS FULL| STG_ELM_CASE | 58828 | 92M| 4407 (1)| 00:00:01 |
----------------------------------------------------------------------------------
8 rows selected.
Thanks,
Rahul
|
|
|
|
|
|
|
|
|
|
|
|
|