Techniques for eliminating database table joins based on a join index

摘要: Techniques for processing, in a database management system, query referencing plurality of tables include determining whether join should be performed between first table and second table. The determination is based on particular set one or more columns the referenced index an key column from If it determined that not performed, processed without performing By avoiding joins, substantial savings consumption computational resources are achieved.