fahad_direct - 12:02 am on Oct 16, 2010 (gmt 0)
Hi,I am using left join in my 2 tables having around 2 million records which takes around 8 hours to run,
SELECT t1.id,t1.expense FROM t1 LEFT JOIN t2
ON (t1.expense=t2.expense AND t1.code=t2.code AND t1.name=t2.name AND t1.price=t2.price AND t1.charges=t2.charges AND t1.url=t2.url) WHERE t2.id is NULL
What should be the best index for this query as i haven't indexed yet to speed up the process from hours to minutes.