Performance impact of JDBC connectionstring property “sendStringParametersAsUnicode”

In this blog post, I will demonstrate the default behaviour of JDBC connectionstring property called sendStringParametersAsUnicode and its impact on database performance. The default value for the sendStringParametersAsUnicode property is "true" which means String parameters will be sent to the database server in Unicode format so if you have not configured it in your connectionstring, it will send VARCHAR... Continue Reading →

Advantages of covering Foreign key in Index

We all are aware of the importance of primary key and foreign key constraints in relational database system. In this blog post, I will illustrate the importance of creating an index on Foreign key constraint and how it can impact us adversely if not created initially. Primary key constraint basically guarantees data uniqueness, when you... Continue Reading →

Website Powered by

Up ↑

%d bloggers like this: