In article <a0jutq$lfr_at_nntpa.cb.lucent.com>, frank says...
>
>Hello,
>
>Please give me an explanation on the Query Rewrite, what is it used for.
>
>Thanks in advance
>Frank
>
>
Hi,
the one thing I just remember is the materialized views. Query rewrite is used
with that Oracle feature. And means that Oracle server changes the user's query
in order to get better execute plan. For more details see Oracle8i Concepts.
Regards and HNY.
--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
Received on Mon Dec 31 2001 - 00:02:53 CST
