Newsgroups: comp.databases Path: utzoo!utdoe!peter From: peter@doe.utoronto.ca (Peter Mielke) Subject: Query Optimization (Magic Sets) Message-ID: <1991Feb14.192012.6084@doe.utoronto.ca> Keywords: magic sets Reply-To: peter@doe.utoronto.ca (Peter Mielke) Organization: Dictionary of Old English Project, University of Toronto Date: Thu, 14 Feb 1991 19:20:12 GMT I was just at a talk on relational database query optimization using the technique of "Magic Sets". I was wondering what RDBMSes use any form of query optimization (i myself have been bitten quite a number of times by not writing my SQL query the right way)? Is it still on the user of SQL to format the query in the right way to get the answer the fastest way? -- Peter Mielke peter@doe.utoronto.ca Dictionary of Old English Project utgpu!utzoo!utdoe!peter University of Toronto