Home » SQL & PL/SQL » SQL & PL/SQL » increasing the performance of query
increasing the performance of query [message #273139] Tue, 09 October 2007 03:26 Go to next message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
Sir,
how can i increase the performance of my query in oracle
Re: increasing the performance of query [message #273140 is a reply to message #273139] Tue, 09 October 2007 03:26 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
use the hint /+ go_faster*10 */
Re: increasing the performance of query [message #273141 is a reply to message #273140] Tue, 09 October 2007 03:32 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or, if you're using 10g. set the undocumented init_ora parameter _fast_select=Y
Re: increasing the performance of query [message #273143 is a reply to message #273141] Tue, 09 October 2007 03:33 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
For a serious answer, go to the Performance tuning forum, and read the post at the top of the forum that tells you how to start going about identifying and solving problems with performance.
Re: increasing the performance of query [message #273154 is a reply to message #273141] Tue, 09 October 2007 04:56 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
JRowbottom wrote on Tue, 09 October 2007 09:32

Or, if you're using 10g. set the undocumented init_ora parameter _fast_select=Y

Of course because my hint method doesn't work on a wednesday. Thanks for the pointer Very Happy
Previous Topic: Data retrievel from two tables Problem
Next Topic: Materialized Views
Goto Forum:
  


Current Time: Wed Dec 07 08:31:59 CST 2016

Total time taken to generate the page: 0.09244 seconds