Performance Tuning - 06-20-2012 , 08:02 AM
When I run the query in stored procedure, it takes 7 minutes
When I run the query in ASE open window, it takes 10 seconds
What is the reason, and please help me to understand.
INSERT INTO A
WHERE A.ID = B.ID
I have index on both tables.
Table A- Clustered Index
Table B- Non-Clustered Index
Table A contains 60,000 rows
Table B contains 2 crores of rows
Final output: 1,50,000 rows
Re: Performance Tuning - 10-02-2012 , 06:02 PM
Am 20.06.2012 15:02, schrieb guru4dw (AT) gmail (DOT) com:
they differ. Create the procedure "with recompile". If your in luck, the
optimizer will bless your procedure (sometimes) with a useful plan.