General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>There is filtering in the SELECT in question, but I was trying to establish if the JOIN itself would be affected by the additional index.
>
>In general, optimization is affected when you are selecting a subset of records using a join and/or a filter. The criteria used to determine the qualifying records is what determines optimization. The fields used for the filter or join criteria are the fields that need indexes if they will have an effect on the actual records selected. In your example, the LEFT JOIN basically eliminates any optimization on Table1 because you are retrieving ALL records from Table1. Technically what this is doing is no more that what a SET RELATION does.
So at the end of the day, it isn't going to make any difference.
Kev
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only