2
Hello,
When writing a X++ select statement that requires a like it will always translate into "where buffer.fieldId like '%TEXT%' and ...."
For performance, we sometimes only to do "where like 'TEXT%'..." or " where like '%TEXT' and.... " and using the wildcard symbol on both sides prevents an efficient use of existing indexes if they are avalable.
Currently we can only do this with query objects but it requires a lot of additional code just for one little symbol in the converted SQL.
To solve this we could introduce new "like" keywords as alternatives :
- BeginsLike = SQL : like 'TEXT%'
- EndsLike = SQL : like '%TEXT'
When writing a X++ select statement that requires a like it will always translate into "where buffer.fieldId like '%TEXT%' and ...."
For performance, we sometimes only to do "where like 'TEXT%'..." or " where like '%TEXT' and.... " and using the wildcard symbol on both sides prevents an efficient use of existing indexes if they are avalable.
Currently we can only do this with query objects but it requires a lot of additional code just for one little symbol in the converted SQL.
To solve this we could introduce new "like" keywords as alternatives :
- BeginsLike = SQL : like 'TEXT%'
- EndsLike = SQL : like '%TEXT'
STATUS DETAILS
Needs Votes