(Igor) Can an execution of 3-way join use only indexes and not touch table rows at all? If we have MyISAM tables it’s just impossible. Yet with InnoDB tables it would be possible if we could exploit so called extended keys – the regular secondary keys extended by the components of the primary key.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help