cost of run-times qus5tion.

cost of run-times qus5tion.

Post by DR TE$TH & THE ELECTRIC MAYH » Wed, 29 Oct 1997 04:00:00

If you develop a product that utilizes SQL-Server, are the run-times freely


Fone:801-787-8525  Page: 801-755-3746 - punch in your phone number and hit '#'
DISCLAIMER - These opoi^H^H "dang", ^H, [esc :q :qq !q "NYRGH!" :Q! "Whaddya
mean, Not an editor command?" :wq! ^C^C^C !STOP ^bye ^quit :quit! !halt ...
^w^q :!w :wq! ^D :qq!! ^STOP [HALT!   HALT!!! "Why's it doing this?" :stopit!
:wwqq!! ^Z ^L ^ESC STOP  :bye  bye  bye! M-X-DOCTOR "HELP! I can't get out of
this stupid editor!!!" And how does this make you feel?


1. Query Analyzer - I/O Cost, CPU Cost, and Cost

When you run a query and look at the Execution Plan you
will see three different costs.
1) I/O Cost - estimated cost of all I/O activity for the
2) CPU Cost - estimated cost for all CPU activity for the
3) Cost - cost to the query optimizer in executing this

Obviously all three should be minimized BUT which is more
important to minimize.  When comparing between two
different methodologies for a task, which cost is most
important when deciding which method is best?

                Method 1    Method 2
                ---------   ---------
Total I/O Cost = 0.02632     0.897
Total CPU Cost = 0.000082    0.567001
Total Cost     = 0.032851    0.016438

Method 1 (does 2 Writes and a Read) is much less costly
when it comes to I/O Cost and CPU Cost.  Method 2 (does 1
Read and 1 Write) is half as costly in terms of Cost.

So which Method will produce better performance and why?

Thanks for any help,
Mark Milchuk

2. Acquiring an accurate recordcount.

3. Converting v3.5DOS Run-Time to v4.5w or v5.0w standard or Run-Time

4. JavaBlend and JDBC driver

5. Microsoft Visual C++ Run time library Run time error R6025

6. Need help on design...

7. Getting the counter value after an addnew-SQL SERVER 2000/ADO

8. 2 servers, same subtree cost, drastic clock time difference

9. HELP: Estimated cost doesn't related to execution time

10. Why declare cursor and open cursor both cost same amount of time

11. HELP: Estimated cost doesn't related to execution time

12. Table Scan Costing a lot of time