Such query isn't optimisable via Rushmore. The query fieldname like "searchitem%" is optimisable.
>Hi all,
>I use a query that contain the condition where fieldname like "%searchitem%" in one of my apps to query tables with large numbers of records. Is that a way to optimize the query via Rushmore (ie indexing?)
>Thanks
>Yau
--sb--