PPS Advisory – IP 17 Tools Very Slow on SQL Server Until…

Hi All,

Just passing this along since it came as such a huge surprise.  If you have not noticed Siebel Tools now issues inline views (ILV) SQL that we have never seen before IP 17.  Here is an example:

FROM

       (SELECT TBL1.* FROM (SELECT * FROM dbo.S_APPLET WHERE ((WS_ID = '1-GH5N-4'))) TBL1

                 LEFT OUTER JOIN (SELECT * FROM dbo.S_APPLET WHERE ((WS_ID = '1-GH5N-4'))) TBL2 ON (TBL1.WS_SRC_ID = TBL2.WS_SRC_ID AND (((CASE TBL1.WS_ID  WHEN '1-GH5N-4' THEN 0 END)*100000)+(TBL1.WS_OBJ_VER)) < (((CASE TBL2.WS_ID  WHEN '1-GH5N-4' THEN 0 END)*100000)+(TBL2.WS_OBJ_VER))) WHERE TBL2.WS_SRC_ID IS NULL AND TBL1.WS_DELETE_FLG='N') T1