Query performance tips

You can create one or more indexes to improve the performance of your queries, or to ensure that row values remain unique.

You can tune the performance of your queries by choosing a specific size for the maximum hash.

The UltraLite default maximum hash size of 4 bytes suits most deployments.

UltraLite execution plans show how tables and indexes are accessed when a query is executed.