data retrieval performance
577174May 11 2007 — edited May 12 2007I have a table with more than 5 lakhs tuples. I have indexed the table.
table description is (employee_no date/time in/out)
i wrote a pl/sql procedure to process the data. it will update only one column (specific) but the procedure will scan all tuple and findout the tuple then update.
procedure has one input parameter. it will take one date as input from front end and process all employee data.
When i tried to execute in oracle. it is taking 3 to 4 hours. some times the client system is hanging.
please guide me to solve this problem