Re: Join Optimization.

In article <3eitsc$t7l@gagme.wwa.com>, Lily Moy Gulik <lily@gagme.wwa.com> wrote: >I've been working with Informix for a number of years and right now I >am in the middle of a Data Warehouse project. It's about 100 gig of data >and I am wondering if you knew anything about Red Brick Systems? > >They are supposed to be the data warehouse people (seen their ads) who >have a special "star-schema" that optimizes joins. I hear they are >lightening quick. Any experiences you'd like to share? I believe 'Red Brick' is for On-line Analytical Processing, ie. OLAP. The comp.databases.olap newsgroup should be able to provide you with more info - I have seen this product mentioned frequently over there. I have no experience with it myself. -- ------------------------------------------------------------------------ Chris Wharton, Database Analyst email: cjw@dme.nt.gov.au All comments and opinions (plus anything else that could possibly offend anyone) are mine alone and do not reflect the views of my employer.