You would rather use techniques like e.g. using a (sequential) numeric field instead of (long) strings by using AutoNumber() -especially for keys. Or you would rather sum up a counter of 1 and 0 instead of counting values in a field.
There is no concept of Index in QVDs, but what you can do is you can sort the data before storing in QVD in your required manner so that you don't need to do the ORDER BY in script again, this will load faster.
.png "Luminary Alumni"){kind=icon}
