Interview Question in SQL Server Performance Tuning
Interview Question :: What is the difference in these Java codes:
String sql = new String("SELECT NAME FROM OTHER_SERVICE_MASTER WHERE ACTIVE='Y' AND SERVICE_TYPE='Music'");
StringBuffer sqlb = new StringBuffer("SELECT NAME FROM OTHER_SERVICE_MASTER WHERE ACTIVE='Y' AND SERVICE_TYPE='Music'");
String sql = ""SELECT NAME FROM OTHER_SERVICE_MASTER WHERE ACTIVE='Y' AND SERVICE_TYPE='Music'""
Performance - wise (execution time in milliseconds)
and Resource - wise (minimum memory consumed)
Loading ...