HQL very slow
A HQL query I use is very slow.
What the query should do:
The Query should output two columns:
1.
2.
Ok, the reason why this query is slow is:
How to improve the speed in HQL?
What the query should do:
The Query should output two columns:
1.
Integerµint8 as a concat of the java-type, the letter 'µ' and then the database-native type.2.
int8 (29) what means that the type int8 is used 29 times.Ok, the reason why this query is slow is:
SIZE(t.SQLDatabaseColumn) is executed multiple times.How to improve the speed in HQL?