The
Min Memory Per Query option applies only to sorting and hashing used during
query execution; it does not apply to the sorting that takes place during index
creation. Another option, Index Create Memory, lets you allocate a specific
amount of memory for index creation. Its value is specified in kilobytes.
