optimize the "SELECT" requests in Valentina

[olivier]

Hi,

The advices (to improve the speed of the SQL requests) what one reads 
in SQL books are  they applicable for Valentina?

Ex:

- Not to use "*" in the requests SELECT but the names of columns " 
Column A, column B.... "

- " ORDER BY " is often slow

- Use "BETWEEN" instead of "AND" when it is possible


To use short names of column  (ex: "TypPS") instead of long names of 
column (ex: "Type_Price_Sales") is faster in Valentina?

More generally, you have advices to optimize the "SELECT" requests in 
Valentina?

Thank you

olivier


PS:
- The SOUNDEX can be used in Valentina 2 ?