Re: Big tables

On Mon, 21 Feb 2000 12:34:33 +0100,
"Raimundo" == Raimundo Lozano <rlozano_at_medicina.ub.es> writes:

Raimundo> Now I only hope anybody show me a Raimundo> query with that number of possible rows! ;-)

if table Foo has 1 million rows, following will do the trick:

SELECT * FROM
  Foo, Foo, Foo, Foo, Foo, Foo, Foo,
  Foo, Foo, Foo, Foo, Foo, Foo, Foo;

(i.e., no WHERE-clause). Let me know if you find a good optimizer trick for it :-)

                                                                      Philip

-- 
Not getting what you want is sometimes a wonderful stroke of luck.
-----------------------------------------------------------------------------
Philip Lijnzaad, lijnzaad_at_ebi.ac.uk | European Bioinformatics Institute,rm A2-24


+44 (0)1223 49 4639                 | Wellcome Trust Genome Campus, Hinxton


+44 (0)1223 49 4468 (fax)           | Cambridgeshire CB10 1SD,  GREAT BRITAIN


PGP fingerprint: E1 03 BF 80 94 61 B6 FC  50 3D 1F 64 40 75 FB 53