I have analysed the schema using dbms_utility
--
On Thu, 03 Jan 2002 23:25:18
nlzanen1 wrote:
>
>
>Hi,
>
>Tables Analyzed recently?
>Indexes analyzed recently?
>Histograms possibly?
>
>
>If all else fails hints are there to force a certain execution anyway
>(Oracle must have known that the CBO wasn't/isn't perfect) so just use
>them.
>
>
>Jack
>
>
>
>
>"C.S.Venkata Subramanian" <csvenkata_at_lycos.com>@fatcity.com on 04-01-2002
>06:40:21
>
>Please respond to ORACLE-L_at_fatcity.com
>
>Sent by: root_at_fatcity.com
>
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
>
>Dear All,
>I have been entrusted to tune a web based application. This product is at
>development stage. I generated the trace file and found out the indexes on
>the table. So I specified hints in all the queries and tested the
>application. There was a remarkable increase in performance. Can any one
>tell me why we have to specify the hints in the queries, when the tables
>are having index already.
>
>Platform: WinNT Oracle 8.1.6. Application is developed in JSP and Web
>server is iPlanet Enterprise Edition.
>
>TIA
>
>Regards
>Venkat
>
>
>--
>Click here for your very own create-a-date adventure from MatchMaker
>Go to http://ecard.matchmaker.com/dating.html
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: C.S.Venkata Subramanian
> INET: csvenkata_at_lycos.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
>===================================================================
>De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor
>de geadresseerde. Gebruik van deze informatie door anderen dan de
>geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding
>en/of verstrekking van deze informatie aan derden is niet toegestaan.
>Ernst & Young staat niet in voor de juiste en volledige overbrenging van de
>inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
>===================================================================
>The information contained in this communication is confidential and may be
>legally privileged. It is intended solely for the use of the individual or
>entity to whom it is addressed and others authorised to receive it. If you
>are not the intended recipient you are hereby notified that any disclosure,
>copying, distribution or taking any action in reliance on the contents of
>this information is strictly prohibited and may be unlawful. Ernst &
>Young is neither liable for the proper and complete transmission of the
>information contained in this communication nor for any delay in its
>receipt.
>===================================================================
>
>
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author:
> INET: nlzanen1_at_EY.NL
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
--
Click here for your very own create-a-date adventure from MatchMaker
Go to http://ecard.matchmaker.com/dating.html
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: C.S.Venkata Subramanian
INET: csvenkata_at_lycos.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Jan 04 2002 - 06:19:45 CST
