If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
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