https://community.databricks.com/t5/get-started-discussions/thoughts-on-how-to-improve-string-search-queries/m-p/50299#M6075 <P>Please see sample code I am running below. What options can I explore to improve speed of query execution in such a scenario? Current full code takes about 4 hrs to run on 1.5 billion rows. Thanks!<BR /><BR />SELECT<BR />&nbsp;fullVisitorId<BR />&nbsp;,VisitId<BR />&nbsp;,EventDate<BR />&nbsp;,PagePath<BR />&nbsp;,deviceCategory&nbsp;<BR />FROM ga360.ga_sessions a<BR />WHERE<BR />(<BR />contains(lower(PagePath) , 'step-one')<BR />OR contains(lower(PagePath) , 'step-two')<BR />OR contains(lower(PagePath) , 'step-three')<BR />)<BR />AND not contains(utm_source,'ads')<BR />AND hitstype = 'PAGE'<BR />and a.EventDateKey &gt;= 20200101</P> Wed, 01 Nov 2023 20:47:58 GMT Bhanu1 2023-11-01T20:47:58Z https://community.databricks.com/t5/get-started-discussions/thoughts-on-how-to-improve-string-search-queries/m-p/50299#M6075 <P>Please see sample code I am running below. What options can I explore to improve speed of query execution in such a scenario? Current full code takes about 4 hrs to run on 1.5 billion rows. Thanks!<BR /><BR />SELECT<BR />&nbsp;fullVisitorId<BR />&nbsp;,VisitId<BR />&nbsp;,EventDate<BR />&nbsp;,PagePath<BR />&nbsp;,deviceCategory&nbsp;<BR />FROM ga360.ga_sessions a<BR />WHERE<BR />(<BR />contains(lower(PagePath) , 'step-one')<BR />OR contains(lower(PagePath) , 'step-two')<BR />OR contains(lower(PagePath) , 'step-three')<BR />)<BR />AND not contains(utm_source,'ads')<BR />AND hitstype = 'PAGE'<BR />and a.EventDateKey &gt;= 20200101</P> Wed, 01 Nov 2023 20:47:58 GMT https://community.databricks.com/t5/get-started-discussions/thoughts-on-how-to-improve-string-search-queries/m-p/50299#M6075 Bhanu1 2023-11-01T20:47:58Z