If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

------
Thank You PAVB.
Sorry for bothering You but only quick question regarding this.
Someone has adviced me that creating materialized view and setting query rewrite may be good solution (this query is hardcoded in application - i can't change it).
What do you think about this ?

let me see... you are advised to create a 86K rows MV on top of a 87K table... providing you do not have a real huge row lenght in your table which I have reasons to believe is about 100 bytes per row - that would be bad advice; Materialized Views and Query Rewrite are a great solution for a very different problem.

What's your average row lenght on that table?
How often you insert/delete row on that table?

By the way... if you knew the query was hard-coded and you had no chance in hell to modify it... why where you asking for ways of finetuning it? most finetuning involves touching the query.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.