Skip to Content
0
Former Member
Feb 27, 2009 at 03:05 PM

INNER JOIN PERFORMANCE ISSUE

511 Views

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.