This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Hi, For reporting purpose I am displaying some records in browser from one database(MSSQL) table based on some criteria.The fields which I am comparing contain 12-13 character strings.In select query I am comparing the values of these fields.If the total records are less say 100000,it works perfectly but total records are more than 500000(which will be the case in 'production'),getting the results take 'long' like 18-19 secods time. Query is very simple,Supoose table T and attributes are A1.....An.and A1 and A2 are attributes which I am using in select query: