SELECT /*+index(pt index_name)*/
pt.type
,pt.address_no
,MIN(pt.partner_id) AS partner_id
FROM partner pt;
pt.type
,pt.address_no
,MIN(pt.partner_id) AS partner_id
FROM partner pt;
--The INDEX_DESC hint instructs the optimizer to use a descending index scan for the specified table.
SELECT /*+index_desc(err)*/ interface_name FROM err;