MAXDB 7.6.06.3
Hello,
I have the following issue JOIN in MAXDB.
I have 2 tables, a MasterTable and a SlaveTable. For each line in the master table, there is one line in the SlaveTable. MSN is the unique key. I have 200.000 records in the table. I had to create a slave table because a line is longer than 8Ko.
I make the following request
SELECT m.msn from MasterTable m, SlaveTable s where m.msn=s.msn
This statement take more than 500 seconds to return, because it create a result table with 200.000 lines.
Is there a way to write statement with JOIN without copy the result, like when you do something like
SELECT * from MasterTable.
If I add a TOP 100 clause in my statement the request is very quick, but if I add an order clause it becomes very slow even if the column in the where clause is indexed.
Thanks
Yann.