On Thursday, February 21, 2013 9:23:40 AM UTC-7, Ninja Li wrote: > > David, > > Thanks a lot for your detailed analysis and explanation. > > The current procedure is using the last_name index. I should clarify that > the input parameter p_in_lastname comes from the front end web application > and it is always upper case, e.g. 'SMITH', so upper() is not necessary > here. > > The current execution time is around 3 to 15 seconds. I would like to ask > if this is reasonable response time given the volumn of the data and > any other improvement on application or table tuning could be doen. The > customer_info table has around 30 columns and account_details 80 columns. > > Thanks. > > Ning > > > On Wednesday, February 20, 2013 5:24:36 PM UTC-5, ddf wrote: > >> >> >> >> That seems to be a reasonable response time to me but I'm not using your system.
David Fitzjarrell -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.