I have a really small table T1 and a really huge table T2. I intend to inner join and get columns from both tables.

What is the best way to do this?

Do a inner join?

```
SELECT * 
FROM T1 
INNER JOIN T2 
    ON T1.col == T2.col

```

or

Filter rows from T2 using a semi join and then do a Inner Join?

```
temp = SELECT * 
FROM T1 
RIGHT SEMIJOIN T2 
    ON T1.col == T2.col;

SELECT * 
FROM T1 
INNER JOIN temp 
    on T1.col == temp.col

```