# xSQL Sample Search

> This sample demonstrates a variety of lookup operations with different orders of comparison operators and `order by` clauses. Note the difference in the execution plans displayed by the `explain` command and the performance statistics displayed using the `trace` command.

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

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