Watson Supply Chain Ideas

Use this form to submit an idea for a new product feature. The product team will review your input and provide status updates as decisions are made regarding the request.

Before you submit a new idea, please view requests that have already been submitted. If your idea has already been submitted, you can add comments or vote on the existing idea, thereby indicating your agreement with the idea. We may use this information to help prioritize development of new features.

 

Submit ideas for Watson Marketing and Watson Commerce products

Query Enhancements

This insert stmt in the table Document, database GIS, is taking around 50% of server resources some days.

On the Insert statement, as you can see bellow, there are 7 variables that are using a varchar() data type.
The table Document is using only nvarchar() data types for character columns.
Due to the data types differences, Sql Server will do an internal conversion during the Insert operation.
The internal conversion slows down the Insert.
We suggest to change the 7 varchar() variables to nvarchar() to help the Insert operation be faster.
A third suggestion would be to create an identity integer column and make it clustered index. That will help with the many Inserts.
  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Dec 19 2017
What is the idea priority? Low
DeveloperWorks ID DW_ID101008
RTC ID RTC_ID529671
Link to original RFE http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=101008
  • Attach files