>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?)

Unfortunately not - since the expression you're looking for contains wildcards and can occur anywhere within the string, there's no way that an ordering like an index could help you AFA performance.