-
Junior Member
Execution time of procedure
In a procedure which has a Select statement execute from 3 to 4 tables then data inserted into a global temporary table. The execution time of procedure hardly 3 - 5 sec. where as its containing SQL statement i.e. select statement when executing in toad its taking atleast 5 - 6 min. So how its possible and what is the logic behind that. one thing the global temporary table have some indexs also.
-
Re: Execution time of procedure
the main reason is temp table and having index on that. and also displaying in toad might take more time to populate the grid incomparision to SQL*PLUS ,but the time of execution should be the same.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules