Home » Other » Training & Certification » what should be the cost of select query in TOAD
what should be the cost of select query in TOAD [message #251863] Tue, 17 July 2007 00:37 Go to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi
I am using TOAD-8.0
Question-1
----------
For efficiency check which one should be taken into account
Cost or Bytes

Question-2
----------
A select query from only one table max how much cost it can take (with where clause & w/o where clause)

Question-3
----------
A join query from 8 tables, max how much cost it can take

Question-4
----------
A update query from a table(say updates 3 columns) max how much cost it can take

Question-5
----------
A delete query from a table, max how much cost it can take

Thanks in advance
sbmk_design
Re: what should be the cost of select query in TOAD [message #251865 is a reply to message #251863] Tue, 17 July 2007 00:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
The homework answer Forum is available below.
Re: what should be the cost of select query in TOAD [message #251895 is a reply to message #251865] Tue, 17 July 2007 01:58 Go to previous messageGo to next message
sbmk_design
Messages: 88
Registered: April 2007
Location: CHENNAI
Member
Hi Mr anacedent.
I could n't understand anything, can you explain clearly

by
sbmk_design
Re: what should be the cost of select query in TOAD [message #251902 is a reply to message #251895] Tue, 17 July 2007 02:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand? Your questions?

Regards
Michel
Re: what should be the cost of select query in TOAD [message #251969 is a reply to message #251863] Tue, 17 July 2007 10:20 Go to previous message
MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA
Senior Member
Google is your friend
Previous Topic: Oracle Financials
Next Topic: Oracle CDs... are they worth it?
Goto Forum:
  


Current Time: Thu Mar 28 04:43:04 CDT 2024