Re: Improving fetch times
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Mon, 06 Aug 2007 12:59:55 +0300
The cause was statistics-level = 'all'.
After I changed it to 'typical' the system works fine.
Adar Yechiel
Rechovot, Israel
Yechiel Adar wrote:
I have a problem with a query that takes a long time to fetch.
Each execution fetch about 6-7,000 rows.
How can I improve the fetch phase?
I will also open a TAR but I decided to ask also for your help.
Other related posts:
- » Improving fetch times
- » Re: Improving fetch times
- » Re: Improving fetch times
I have a problem with a query that takes a long time to fetch. Each execution fetch about 6-7,000 rows. How can I improve the fetch phase? I will also open a TAR but I decided to ask also for your help.