Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have a group by expression using index
Message
 
To
03/06/2002 12:54:38
Christian Cote
Les Logiciels Onoma Inc.
Longueuil, Quebec, Canada
General information
Forum:
Oracle
Category:
Troubleshooting
Miscellaneous
Thread ID:
00663782
Message ID:
00664170
Views:
25
The SUM() forces the sort.

Because the SUM() is for each group it forces the access plan to sort rows so it can sum all rows pertaining to a group.

To prove it, remove the sum()...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform