=Physical Optimizations=
Various of the following optimizations are also presented in the article on [[Indexes|index structures]].
==Database Statistics==
231
</syntaxhighlight>
;Return distinct values
The distinct values for specific names and paths can also be fetched from the database metadata, provided that the number does not exceed the maximum number of distinct values (see {{Option|MAXCATS}} for more information):