-
i have the next query, this is executed by an application, the table table_case have a index in case_wip2wipbin
but not in case_reporter2site, this query make to many physical reads.
hos can optimiza this query without change.
SQL> ED
Wrote file afiedt.buf
1 select /*+RULE*/ count(*) from table_case
2 where ( ( case_wip2wipbin IS NOT NULL ) )
3* AND case_reporter2site IN (268483034)
SQL> /
COUNT(*)
---------
1
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=HINT: RULE
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'TABLE_CASE'
Statistics
----------------------------------------------------------
0 recursive calls
2 db block gets
41448 consistent gets
31242 physical reads
0 redo size
143 bytes sent via SQL*Net to client
281 bytes received via SQL*Net from client
3 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed
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
|