Skip to end of metadata
Go to start of metadata

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)

  • No labels