It is a join algorithm that combines the sort merge and nested loops algorithms. The outer table must be sorted or have a join column index. The inner table must have an index on the join column. This algorithm can only be used for equi-joins.
Tags: Database, Education, Software
Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material. Disclaimer
Home Disclaimer Advertise Contact Privacy Policy
Copyright © 2004-16 Paked.com. All rights reserved.
Note: Site best viewed at 1024 x 768 or higher screen resolution