PLATFORM - Administration > Administrator Guide > Supervision Event Description > RunTimeAlerts > ERQLWarning
ERQLWarning
This alert is issued when it is impossible to perform an SQL optimization of the ERQL query. ERQL queries generating less than 100 non-optimized SQL queries are not taken into account.
Context (JSON)
Comment
QueryId or QueryName
IdAbs or name of the query involved
Root Cause
Reason for the impossibility to optimize
 
Using some attribute(s) no indexable to Filter which contains OR as Operator
 
The MetaClass is Virtual
 
Either The Link <MetaAssociation> does not exists or The Master <MetaClass> is not concrete or The slave <MetaClass> is not concrete
 
Internal Error (Fail to build makeQuery)
 
Filter on Slave : The Attributes using on slave Filter (<MetaAttribute,...>)
 
FullScan on Table <MetaClass>
 
The MetaClass is Archivable
 
The MetaClass is Virtual Pure With MetaServer
 
Using some attribute(s) no indexable to Filter
 
Using some attribute(s) no indexable to sort
 
Execution on mode no Optimization