OraFAQ Forum: Performance Tuning » choosing the right query

Home » RDBMS Server » Performance Tuning » choosing the right query

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

choosing the right query [message #124412]

Sat, 18 June 2005 04:02

srraajesh
Messages: 63
Registered: May 2005

Member

I have two sql queries. It is a join on two tables.

Query 1>

Does not use index on one table. The consistent get count in autotrace is around 15.

Query 2>

Uses index on both the tables. The consistent get count in autotrace is 360.

The rest of the parameters in autotrace output is the same. Can anyone help me out in choosing the right one??

Thanks much
Raajesh

Report message to a moderator

Re: choosing the right query [message #124440 is a reply to message #124412]

Sat, 18 June 2005 09:28

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Choose the one that gets the right answer?

Choose the one that runs the fastest?

Report message to a moderator

Re: choosing the right query [message #124481 is a reply to message #124412]

Sun, 19 June 2005 04:10

srraajesh
Messages: 63
Registered: May 2005

Member

Both the queries gives the correct answer only.

Could you please explain the significance in terms of consistent gets..

Thanks
Raajesh

Report message to a moderator

Re: choosing the right query [message #124484 is a reply to message #124481]

Sun, 19 June 2005 06:23

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

YOu have asked the same question and has been answered before.

http://www.orafaq.com/forum/t/47427/42800/

Report message to a moderator

Previous Topic:	how to avoid the full table scan?
Next Topic:	Measuring time exection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 27 06:21:22 CST 2025