This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 35%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPJ%3C/text%3E%3C/svg%3E)
I have azure sql database (vcore) . I am running query select col1, col2, col3, col4, col5 where vpkgname ='xxxxxxxxxxxxx' . Please note that non cluster index is already set on where condition col "vpkgname" (nvarchar). This query is reading 2 millions record to fetch specific result in 1.5 second when I am running on azure sql query tool. The same query is taking 0.5 second( half the time) in AWS rds database with similar records. IS THERE ANY recommended database setting I need to check/configure in azure sql database to reduce query time ? Or only option left is to increase vcore size?
An Azure relational database service.
@Anonymous Thanks for posting your question in the Microsoft Q&A forum.
Can you please share more details about the number of vcores, and service tier of Azure SQL DB? What you are comparing against? If there is a proper index and the data is unique, why does it need to read 2 million rows?
Please share more details about this comparison to make a conclusion. Query execution plan would be another thing to compare to understand the wait stats.
Regards
Geetha
@Anonymous We haven't heard back from you. Just wanted to check if you had the chance to check my response.
Regards
Geetha
Actually on further investigation it was found when java spring boot application invoking query it's somehow sending query with adding extra string "@nvarchar(2000) " due to unknown reason (as shown below complete query) due to which query taking extra time when running on azure sql database. (@Nvarchar(2000) select col1, col2, col3, col4, col5 where vpkgname ='xxxxxxxxxxxxx' ) . We are trying to figure out why this string got concatenated in the beginning of query when invoking from java spring boot code, I assume it's because of this query taking more time to return response.
Answer accepted by question author
@Anonymous Please take a look at this: Default parameterization of varchar to nvarchar in sql driver | by Vinodhini Chockalingam | Medium.
It’s a pretty common issue that can be solved at the config level or in your code, depending on the data access flavor you are using in Spring.
Hope this helps
Regards
Geetha
@Pankaj Joshi We haven't heard back from you. Just wanted to check if you had the chance to check my response