Siebel System Admin, Install and Upgrade (MOSC)

MOSC Banner

IP 17 SQL Server Full Publish Performance Fixed in SS 16

edited Apr 25, 2018 10:11AM in Siebel System Admin, Install and Upgrade (MOSC) 2 commentsAnswered

Hi All,

Happy to report that the very severe performance issue that caused Tools Full Publish to run for days in SQL Server 2012 R2 have been fixed in SQL Server 2016.  On the newer SQL Server version performance is on par with Oracle 12c for the hash joins issued during the full publish process.

Here is an example of the problem SQL that requires a hash join.  As you can see now with workspaces Siebel creates inline views (ILVs) instead of just querying against the base tables.

   FROM

       (SELECT TBL1.* FROM (SELECT * FROM dbo.S_LIST_COLUMN WHERE ((WS_ID = '1-1765-4'))) TBL1 LEFT OUTER JOIN (SELECT * FROM dbo.S_LIST_COLUMN WHERE ((WS_ID = '1-1765-4'))) TBL2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

SBL Sys Admin Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center