CodingForums.com - View Single Post

Mayhem30 · 01-19-2013, 06:48 AM

I'm testing out this comment script and the author did not include any indexes. I was able to go through the script and index everything - except the LEFT JOIN.

PHP Code:


			
SELECT DISTINCT pac2_titles.title AS page_title, pac2_notifications.* FROM pac2_notifications LEFT JOIN pac2_titles ON pac2_titles.uri = pac2_notifications.what WHERE `what` = '/demo.php' AND `email` != 'hehe@aol.com'

Any ideas how to properly index this?

01-19-2013, 06:48 AM	PM User \| #1
Mayhem30 New Coder Join Date: Jan 2010 Posts: 63 Thanks: 2 Thanked 5 Times in 4 Posts	How to properly index this LEFT JOIN? I'm testing out this comment script and the author did not include any indexes. I was able to go through the script and index everything - except the LEFT JOIN. PHP Code: SELECT DISTINCT pac2_titles.title AS page_title, pac2_notifications.* FROM pac2_notifications LEFT JOIN pac2_titles ON pac2_titles.uri = pac2_notifications.what WHERE `what` = '/demo.php' AND `email` != 'hehe@aol.com' Any ideas how to properly index this?