In sybase IQ I have a store procedure that loads 10 lakhs records into an empty working table. After loading it takes each record from the working table and compares it with records in main table . The problem is main table has around 1 crore records and 94 columns .
Can u pls tell me any SQL performance improvement tat can be done to this SP ?
As of now my store procedure hangs in the part where it compares each column of 9 lak records with 1 crore in main table .
Ur help is highly appreciated .. thanks in advance
I have some questions first.
1. from where u r loading 10 lakh records in working table (from any other table using select or from a flat file) ?
2. is it possible to create a view by joining two tables(the main table and the working table) and then create another working table with matching rows ?