info
Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Performance Tuning
89 views
Skip to first unread message
gur...@gmail.com
Jun 20, 2012, 9:02:53 AM6/20/12
to
Hi,
Question:
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.
Query:
INSERT INTO A
Select
....
....
FROM A
JOIN B
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
Question:
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.
Query:
INSERT INTO A
Select
....
....
FROM A
JOIN B
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
Milo Minderbinder
Oct 2, 2012, 7:02:03 PM10/2/12
to
they differ. Create the procedure "with recompile". If your in luck, the
optimizer will bless your procedure (sometimes) with a useful plan.
Milo
0 new messages