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.