Thanks Brigitta, although I didn't need any sorting.
I visited Karlsruhe yesterday evening. Anywhere near you?
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de BirgittaHauser
Envoyé : jeudi 7 août 2008 10:07
À : 'Midrange Systems Technical Discussion'
Objet : AW: SQL : subtotals and total
Hi,
Without an explicit request to ORDER BY, there is nothing for sure to
be /followed by/ anything, regardless of how many times the given
SELECT may *appear* to effect some perceived ordering.
What you say?
If you need a predefined sequence in your result set, you need to add an order by clause.
Even if you specify a logical file with right key fields(which is not a good design because the queries must be executed by the CQE), the optimizer may use a different access path with an other sequence and consequently the result is not sorted in the expected way.
The optimizer searches for a way to get the requested data as fast as possible and if necessary sortes the data after selection.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is worse than training your staff and losing them? Not training them and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
Gesendet: Thursday, August 07, 2008 09:39
An: Midrange Systems Technical Discussion
Betreff: RE: SQL : subtotals and total
Chuck wrote:
Without an explicit request to ORDER BY, there is nothing for sure to
be /followed by/ anything, regardless of how many times the given
SELECT may *appear* to effect some perceived ordering.
What you say?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
