Did you try to provide an index? Something lik "index hint confirmedDlvSalesIDx ... Sometimes Oracle seems to need those hints.
Best regards, Tobias
> -----Ursprüngliche Nachricht-----
> Von: development-axapta@yahoogroups.com [mailto:development-
> [EMAIL PROTECTED] Im Auftrag von Mikael Dalgård (GPV International
> A/S)
> Gesendet: Donnerstag, 16. Februar 2006 14:27
> An: development-axapta@yahoogroups.com
> Betreff: [development-axapta] Speed issue
>
> Dear experts
>
>
>
> << Speed issue: >> Help needed
>
>
>
>
>
> While running the code "below" on our SQL 2000 database, the progress
> takes no time. But while running the same code on Oracle 9 database
> (yawn), it surely takes some time.
>
>
>
> while select * from saleslines order by ConfirmedDlv, SalesId where
> saleslines.SalesStatus == SalesStatus::Backorder
>
>
> && saleslines.SalesType == SalesType::ReturnItem
>
>
> || saleslines.SalesType == SalesType::Sales
>
>
>
> Suggestions wanted :-)
>
>
>
> Best regards
>
>
>
> Mikael Dalgård
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
SPONSORED LINKS
Computer part | Programming languages | Microsoft axapta |
Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.