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
========= WAS CANCELLED BY =======:
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!newsfeed.media.kyoto-u.ac.jp!newsfeed.mesh.ad.jp!osa.uu.net!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
From: Roman Mirzaitov<rmirzaitov_at_kt.kg>
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.server
Subject: cmsg cancel <hcTX7.15861$XC5.14096_at_www.newsranger.com>
Control: cancel <hcTX7.15861$XC5.14096_at_www.newsranger.com>
Date: Wed, 2 Jan 2002 03:38:40 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.hcTX7.15861$XC5.14096_at_www.newsranger.com>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009945060 21023 166.102.15.34 (2 Jan 2002 04:17:40 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 2 Jan 2002 04:17:40 GMT
X-No-Archive: yes
Comment: Dude, where's my NewsAgent?
Xref: news.uni-stuttgart.de control:40280401
autocancel
Received on Mon Dec 31 2001 - 00:02:53 CST
