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" <[EMAIL PROTECTED]>@fatcity.com on 04-01-2002 >06:40:21 > >Please respond to [EMAIL PROTECTED] > >Sent by: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
