How to use INNER JOIN?

[Pavel Polívka]

Hi,

I've been experiencing very long execution times on some specific queries when using LEFT JOIN. I found out, that MSSQL server is using "bad" execution plan (many paralisms, using worktables, etc.) for such query. When I changed one problematic LEFT JOIN to INNER JOIN everything went fine - in numbers: From about 90 seconds to less than one second and the execution plan is flawless now.

Is there any way how to use INNER JOIN instead of LEFT JOIN, or are there plans to implement it?

I've already made some customizations to NotORM (because this problem was crucial for me) and implemented following construction:
$table->select('table1..column') or rather $table->select('table1::column') which generates INNER JOIN instead of LEFT JOIN but I'd like see support for this in default NotORM.

Thanks for any information about this topic.

[Jakub Vrana]

NotORM doesn't support INNER JOIN. The best way is usually to avoid all
joins and use NotORM's relations.

Jakub