Re: [PL/SQL] Search by last name procedure design

2013-02-21 Thread عبادي الشمراني
بتاريخ الخميس، ٢١ فبراير، ٢٠١٣، جاء من ddf orat...@msn.com: On Wednesday, February 20, 2013 12:50:09 PM UTC-7, Ninja Li wrote: Thanks for your replay. There is b-tree index on last_name, Partition is actually on a different column bill_num, which is also used for search. However in this

[PL/SQL] Search by last name procedure design

2013-02-19 Thread Ninja Li
Hi, I would like to ask for some advice on the design of PL/SQL procedure. I am trying to improve the performance of a PL/SQL procedure which allows a user to do search by their last name and returns their account information. I will be joining two tables, customer_info (with last name as a