Hi all. 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. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
