Need to improve a query which is taking longer time
Hi All,
we have the requirement like based on attribute (non index) column , need to filter the data. could any of you please help me to improve the performance
SELECT MAX (gl_date) FROM AP_INVOICES_ALL
WHERE attribute_category = 'abc'
AND attribute6 = 'rewer'
AND source = 'fdsd'
Plan
SELECT STATEMENT ALL_ROWSCost: 435,203 Bytes: 36 Cardinality: 1
2 SORT AGGREGATE Bytes: 36 Cardinality: 1
1 TABLE ACCESS FULL TABLE AP.AP_INVOICES_ALL Cost: 435,203 Bytes: 36 Cardinality: 1