ASE 15.0 introduced a new AP warning message that is sent to the client when a query hint is ignored due to the existence of input AP.
Traceflag 15381 causes ASE to not send the warning message.
Example of warning message:
select *
from (select distinct c1 from t1 (index i1)) trd, t2
where trd.c1=c3
plan '(plan
()
( store Worktab1 ( t_scan ( table t1 ( in ( view trd ) ) ) ) )
( nl_g_join ( t_scan t2 ) ( t_scan ( work_t Worktab1 ) ) ) )'
go
Abstract Plan (AP) Warning: all FROM clause forced options (and their internally generated AP, given below) were ignored.
( hints ( also_enforce ( i_scan i1 t1 ) ) )
The following AP, given in the PLAN clause, was used by the optimizer:
( legacy_sequence ( values ) ( store Worktab1 ( t_scan ( table t1 ( in ( view
trd ) ) ) ) ) ( nl_join ( t_scan t2 ) ( t_scan ( work_t Worktab1 ) ) ) )
c1 c3 c4
----------- ----------- -----------
(0 rows affected)