|
-
i have the next query
SQL> select count(*)
2 from table_case;
COUNT(*)
---------
82379
real: 5830
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Cost=3833 Optimizer=CHOOSE
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'TABLE_CASE'
Statistics
----------------------------------------------------------
0 recursive calls
2 db block gets
39846 consistent gets
25244 physical reads
0 redo size
141 bytes sent via SQL*Net to client
181 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
if i want tune the query, the execution plan have a full access in table_case, this is logic by the query, but how i can decrese de physical reads?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|