query rewrite help

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 29 Dec 2003 08:18:59 -0800
Message-ID: <1efdad5b.0312290818.41ddaa6a@posting.google.com>

Having trouble getting it to work.

I have 4 tables. All need to be joined to answer a query. 3 are non-transactional. For performance reasons, I pre-joined these 3 tables in a materialized view, then I want to join that view to the one transactional table.

I cant get query re-write to pick up on this, if my users issue a select statement to all 4 original tables. Is this possible? The users have an analytic function in their query, could this be interferring with it?

Not sure if dimensions will work, since the docs lead me to believe, its for use with 'rollups', these are just straight joins, with an analytic function in the final query(query is just doing some counts... and the developers dont want to take it out).

can I get query re-write to work here? Or should I look for an alternative solution? Received on Mon Dec 29 2003 - 10:18:59 CST