# optimize ej (equijoin)

**URL:** <https://forum.kx.com/t/optimize-ej-equijoin/10873>\
**Category:** Community Support\
**Tags:** kdb-and-q\
**Created:** [March 10, 2016, 7:13pm UTC](https://forum.kx.com/t/optimize-ej-equijoin/10873 "2016-03-10T19:13:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sam11](https://avatars.discourse-cdn.com/v4/letter/s/c6cbf5/32.png) [@Sam11](https://forum.kx.com/u/Sam11)\
**Post date:** [March 10, 2016, 7:13pm UTC](https://forum.kx.com/t/optimize-ej-equijoin/10873/1 "2016-03-10T19:13:00Z")

</div>

How do I optimize equijoin?

Table 1 has 500000 rows, Table 2 has 200,000 rows and I need to do equi join between them.

The resulting table should have about 20,000,000 rows. It takes about 20 seconds currently to run -

```
ej[`key;Table1;Table2]

```

I tried some attributes on the ‘key’ column to no avail.