AnsweredAssumed Answered

Is there a more efficient way to search than with eSQL and "LIKE" ?

Question asked by disabled_Luna.media on Jan 31, 2015
Latest reply on Feb 1, 2015 by Vincent_L

Hi,

 

as a SQL search with the operator "LIKE" is not very efficient (full table scan necessary) are there better approaches if you want to offer a "multiple table general search" like: you type in a phrase like "Luna" and you want to get all companies, employees, products etc. with the string "Luna" somewhere in it.

Outcomes