[EMAIL PROTECTED] wrote:
> I have used SAPDB version 7.4.03.31
> I used LEFT JOIN in SELECT statement.
> It was executed very fast because I had defined indexes on
> all column which
> taked part
> in LEFT JOIN.
> When I used EXPLAIN before SELECT in SQLStudio, it showed
> that all joins
> used indexes.
> Total COSTVALUE IS: PAGECOUNT = 2440
>
> What I did
>
> I made backup of my database on SAPDB version 7.4.03.31
> I have installed SAPDB version 7.4.03.32
> I have restored backup of my database on SAPDB version 7.4.03.32.
>
> I try to execute the same SQL (SELECT with LEFT JOIN) which I
> executed on
> ver 7.4.03.31. It executes
> successfully but last too much time.
> When I use EXPLAIN before SELECT in SQLStudio, it shows that
> joins don't use
> indexes but
> TABLE SCAN is executed in the result total COSTVALUE IS:
> PAGECOUNT=1600000
>
> Summary: SQLs with LEFT JOINs on ver. 7.4.03.31 are executed
> faster than
> SQLs with LEFT JOINs on version 7.4.03.32.
>
> How can I resolve this problem. I will be grateful for all
> information and
> advices.
Hi,
did you ever use
"dbmcli -d <dbname> -u <usr,pwd>
util_execute diagnose optimize join outer off"
to speed up outer join execution?
If yes, you should keep on mind to execute this statement
after each restart of the MaxDB.
In further releases we will make this switch persistent.
Best regards,
Holger
SAP Labs Berlin
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
