Re: 0,08 secs + 0,12 secs = 2 minutes when joined
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 30 Apr 2009 07:11:30 +0100
Message-ID: <Pe6dnQJOtZOL3GTUnZ2dnUVZ8rCdnZ2d_at_bt.com>
Date: Thu, 30 Apr 2009 07:11:30 +0100
Message-ID: <Pe6dnQJOtZOL3GTUnZ2dnUVZ8rCdnZ2d_at_bt.com>
"Sébastien de Mapias" <sglrigaud_at_gmail.com> wrote in message news:70e70aab-f650-4c41-b847-c4ff724644d8_at_w31g2000prd.googlegroups.com...
If I remove (comment out) the view and the where clauses lines related to it, the response time is immediate; if I run the select on the view alone, with "view.xx = value", "view.yy = value"... as returned by the previous statement, the response time is also immediate.
You've done the right analysis, and just need to find the set of hints that enforces your strategy. I've made some comments and a suggestion at the following URL:
http://jonathanlewis.wordpress.com/2009/04/28/strategic-hints/
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Thu Apr 30 2009 - 01:11:30 CDT