ASA SQL User's Guide
Query Optimization and Execution
Storage allocations for each table or entry have a large impact on the efficiency of queries. The following points are of particular importance because each influence how fast your queries execute.
Disk allocation for inserted rows
Table and page sizes