bad plan in case of joining a big table with empty temporary table

[Alexey Gaidukov]

MaxDB 7.6.00.27

The testcase
gis.invest is a table with millions records. The field COUNTER is the 
PRIMARY KEY



create table temp.test (
id integer
)
//
explain
select * from gis.invest,temp.test where counter=id
for reuse


TEMP  TEST             TABLE SCAN                                       0
GIS   INVEST  COUNTER  JOIN VIA KEY COLUMN                          69584
                           NO TEMPORARY RESULTS CREATED      
                           RESULT IS COPIED   , COSTVALUE IS     > 2 E10



insert into temp.test values(1)
//
explain
select * from gis.invest,temp.test where counter=id
for reuse


TEMP  TEST             TABLE SCAN                                       0
GIS   INVEST  COUNTER  JOIN VIA KEY COLUMN                          69584
                           NO TEMPORARY RESULTS CREATED      
                           RESULT IS COPIED   , COSTVALUE IS           2


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]