Re: How Big is Big enough

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 22 Nov 1999 17:06:09 +0800
Message-ID: <38390781.2014@yahoo.com>

ole c meldahl wrote:
>
> Jonathan Lewis wrote:
>
> > Personally I reckon that 40 rows will do for
> > a query to last a 600 MHz CPU for about
> > a year, and 75 rows should be enough to
> > keep it running until the heat death of the universe.
>
> Interesting! Could you give me the specifics of your computations so I
> can interpolate the number of rows necessarry to keep the query going
> about 40 years. I need somthing to keep me occupied until I retire;-)
>
> ole c-:

From Johathon's web site (a slight variant thereof)

	create table t (n number)	as 
	select rownum n 
	from all_objects 
	where rownum <= 21  
	/

	select count(*) from t
	connect by n > prior n
	start with n = 1
	;

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Mon Nov 22 1999 - 03:06:09 CST