[SQL] Re: [SQL] Table indexes in a SELECT with JOIN´s

2013-04-20 Thread Pavel Stehule
Hello 2013/4/20 JORGE MALDONADO > Let´s suppose that I have a SELECT statement that joins more than one > table and such a statement is order by fields that belong not only to the > table in the FROM but also by fields in the tables that are part of the > JOIN´s. How does indexes should be cons

[SQL] Table indexes in a SELECT with JOIN´s

2013-04-20 Thread JORGE MALDONADO
Let´s suppose that I have a SELECT statement that joins more than one table and such a statement is order by fields that belong not only to the table in the FROM but also by fields in the tables that are part of the JOIN´s. How does indexes should be considered in a case like this? For example: SE