I am having 7 lacs records in one table.
Table having id,name,address,pincode,etc etc.
I have 17 indexes on the table.
While fetching data from table like:
ex:select empname from employee where empname like 'AB%' order by employee name;
Result:Session time out error!!!(We set session of 180 sec)
We do not want to increase session time.
Please suggest ur inputs....
How to post a tuning request -
HOW TO: Post a SQL statement tuning request - template posting
When your query takes too long ...