Re: SQL statement performance question

[NGay@xxxxxxxxxxxxx]

My experience with SQL is that its completely unpredictable.  The only way
to be 100% sure which query is faster on your iSeries configuration
retrieving from that particular table is to write some code to run each
query 100 or 1000 times and see which one is fastest, although in the case
of just picking which fields you want from the same table I doubt you'll
notice any difference.

Nigel.



|---------+------------------------------>
|         |           Ashish Kulkarni    |
|         |           <kulkarni_ash1312@y|
|         |           ahoo.com>          |
|         |           Sent by:           |
|         |           java400-l-bounces@m|
|         |           idrange.com        |
|         |                              |
|         |                              |
|         |           01/04/2004 19:08   |
|         |           Please respond to  |
|         |           Java Programming on|
|         |           and around the     |
|         |           iSeries / AS400    |
|         |                              |
|---------+------------------------------>
  
>--------------------------------------------------------------------------------------------------------------|
  |                                                                             
                                 |
  |       To:       java400-l@xxxxxxxxxxxx                                      
                                 |
  |       cc:                                                                   
                                 |
  |       Subject:  SQL statement performance question                          
                                 |
  
>--------------------------------------------------------------------------------------------------------------|




Hi
which SQL statement is more efficient

SELECT * FROM mytable

  OR
SELECT A, B, C FROM mytable

Why is it more efficient,
If there are any articles about writing efficient SQL
querries will really help


Ashish

__________________________________
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/design_giveaway/
_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.








********************************************************************************
The information in this message is confidential and may be legally
privileged. It is intended solely for the addressee; access to this
email by anyone else is unauthorised.

If you are not the intended recipient: (1) you are kindly requested
to return a copy of this message to the sender indicating that you
have received it in error, and to destroy the received copy; and (2)
any disclosure or distribution of this message, as well as any action
taken or omitted to be taken in reliance on its content, is prohibited
and may be unlawful.
********************************************************************************