Re: simulating a select returning a million rows?
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 13 Jun 2009 11:59:25 +0200
Message-ID: <79hbkcF1qc6niU4_at_mid.individual.net>
On 07.06.2009 02:03, mh_at_pixar.com wrote:
> Peter Nilsson <airia_at_acay.com.au> wrote:
>
> Both of these are working perfectly for me... thanks to
> both of you!
Date: Sat, 13 Jun 2009 11:59:25 +0200
Message-ID: <79hbkcF1qc6niU4_at_mid.individual.net>
On 07.06.2009 02:03, mh_at_pixar.com wrote:
> Peter Nilsson <airia_at_acay.com.au> wrote:
>> Malcolm Dew-Jones wrote: >>> select rownum from dual connect by rownum <= 1000000 >> More common is... >> >> select level from dual connect by level <= 1000000
>
> Both of these are working perfectly for me... thanks to
> both of you!
But keep in mind that if you are investigating execution plans the mere fact that you do not query a real table might dramatically change the plan in question probably making the exercise useless.
Kind regards
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sat Jun 13 2009 - 04:59:25 CDT