Very Computer

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
operation.
2) CPU Cost - estimated cost for all CPU activity for the
operation.
3) Cost - cost to the query optimizer in executing this
operation.

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