This discussion is archived
1 Reply Latest reply: Jul 20, 2013 6:26 AM by Srini Chavali-Oracle RSS

Need to tune DB

Prince_Kaileena Newbie
Currently Being Moderated

Hi Folks,

 

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....

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points