sentinel-attack icon indicating copy to clipboard operation
sentinel-attack copied to clipboard

Improve queries performance: replace 'contains' with 'has'

Open sloutsky opened this issue 5 years ago • 0 comments
trafficstars

In Kusto (the underlying database engine used for Sentinel) : for the cases when the full worked is looked up - it is better (perf-wise) to use 'has' instead of 'contains'.

See Kusto best query practices: https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/best-practices

"When using string operators: Prefer has operator over contains when looking for full tokens. has is more performant as it doesn't have to look-up for substrings."

sloutsky avatar Jul 12 '20 05:07 sloutsky