what should be the cost of select query in TOAD [message #251863] |
Tue, 17 July 2007 00:37 |
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
|
|
|
|
|
|
|