OraFAQ Forum: SQL & PL/SQL » query to work fast

Home » SQL & PL/SQL » SQL & PL/SQL » query to work fast (oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

query to work fast [message #602233]

Mon, 02 December 2013 04:05

DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA

Junior Member

hello,
i want my sql query to work fast,as there is multiple filters in my query.

is there any sol for that.

thanks

Report message to a moderator

Re: query to work fast [message #602234 is a reply to message #602233]

Mon, 02 December 2013 04:10

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Ask your DBA to set FAST=TRUE

Report message to a moderator

Re: query to work fast [message #602235 is a reply to message #602233]

Mon, 02 December 2013 04:14

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Or you could add a filter "where 1=2" to your query.

Of course, if you want to optimize the query you could also read the sticky post in the performance tuning forum.

[Updated on: Mon, 02 December 2013 04:15]

Report message to a moderator

Re: query to work fast [message #602236 is a reply to message #602233]

Mon, 02 December 2013 04:17

dariyoosh
Messages: 538
Registered: March 2009
Location: France

Senior Member

In addition reading Oracle® Database Performance Tuning Guide might help. Smile

Report message to a moderator

Re: query to work fast [message #602239 is a reply to message #602234]

Mon, 02 December 2013 05:18

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Michel Cadot wrote on Mon, 02 December 2013 10:10

Ask your DBA to set FAST=TRUE

One of my favourite all time responses to questions of this ilk.

Report message to a moderator

Re: query to work fast [message #602263 is a reply to message #602233]

Mon, 02 December 2013 08:27

John Watson
Messages: 8930
Registered: January 2010
Location: Global Village

Senior Member

Make sure that all the keywords are in UPPER CASE

Report message to a moderator

Re: query to work fast [message #602265 is a reply to message #602263]

Mon, 02 December 2013 08:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>query to work fast (oracle 9i)
upgrade to a supported Oracle version that is supported in this Century.

Report message to a moderator

Re: query to work fast [message #602294 is a reply to message #602239]

Mon, 02 December 2013 16:55

rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia

Senior Member

pablolee wrote on Mon, 02 December 2013 22:18

Michel Cadot wrote on Mon, 02 December 2013 10:10

Ask your DBA to set FAST=TRUE

One of my favourite all time responses to questions of this ilk.

I'm using SQL Server in my current project. While I used to enjoy this particular irreverent response, I now worry (a little ... not much) that anyone coming from SQL Server will take it seriously because MS actually has a FAST hint. It works much the same as FIRST_ROWS(n).

Ross Leishman

Report message to a moderator

Re: query to work fast [message #602296 is a reply to message #602294]

Mon, 02 December 2013 17:35

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Well, every day is school day! I may have to start stealing John's very amusing retort Smile

.
I had a (very quick) look at the hint. As you say, very 'first_rows' not a fan of the nomenclature, a little bit misleading I feel.
Cheers for the heads up.

Report message to a moderator

Previous Topic:	How to get ddls for objects in DB and write them to a file
Next Topic:	split long string

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 09:55:34 CDT 2024