xSQL Sample Indexjoin

This sample demonstrates the use of an index to optimize a lookup operation. Note how the explain command displays different execution plans depending on the order of conjunctions in the where clause.

This sample can be run from directory samples\xsql\scripts with the following command:

 
    ..\..\..\target\bin\xsql.exe -b -c xsql.cfg -f indexjoin.sql