Sometimes it is necessary to force the index when the optimizer has incorrect statistics.
-- Example: Force the idx_emp index in this query
select t1.emp_id, t1.emp_name, t2.status
from employee t1 (index idx_emp),
audit_flags t2
where t2.emp_id = t2.emp_id
go
|
|
