Re: Relational Algorithms

On Wed, 03 May 2000 21:34:34 GMT,
"Joe" == Joe Celko <71062.1056_at_compuserve.com> writes:

Joe> No, that one is really dumb.

(surprising how often people still think this. Maybe the OODBMS pushers are be perpetuating this nonsense ?-)

Joe> There are a few basic ones from
Joe> relational algebra -- do non-correlated subqueries once, avoid cross
Joe> joins, etc.  David Maier's THEORY OF RELATIONAL DATABASES might help
Joe> there.

checked www.amazon.com, but the book is out of print. Do you have any other book suggestions on RDBMS implementation/optimization. Cheers,

                                                                      Philip

-- 
/dev/brain/lost+found: File not found
-----------------------------------------------------------------------------
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