<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Speed up the execution of query activity in Adobe Campaign Standard Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/395253#M1430</link>
    <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As the Query recomputes every time usually it depends on the filters you are using on the data,&lt;/P&gt;&lt;P&gt;and if you really want to purge the data which already having some records and dont wants to recompute and fetch only the latest records we usually recommends to use Incremental Query.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Keerti J&lt;/P&gt;</description>
    <pubDate>Fri, 29 Jan 2021 04:13:05 GMT</pubDate>
    <dc:creator>keertij82676895</dc:creator>
    <dc:date>2021-01-29T04:13:05Z</dc:date>
    <item>
      <title>Speed up the execution of query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/394941#M1428</link>
      <description>&lt;P&gt;What are the main recommendations for speeding up the execution of Query Activity?&lt;/P&gt;</description>
      <pubDate>Wed, 27 Jan 2021 09:42:36 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/394941#M1428</guid>
      <dc:creator>El-Coder</dc:creator>
      <dc:date>2021-01-27T09:42:36Z</dc:date>
    </item>
    <item>
      <title>Re: Speed up the execution of query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/394977#M1429</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;That really all depends on what the query is, how long it's running and the amount of data being pulled and the number of tables being joined.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In general, you want to query against indexed values, pull in only as much data as needed, if joining to other tables ensure that the fields being joined on are indexed.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;There are also a vast number of resources online that you can do a web search on that will give you best practices of querying a database so I'd recommend doing one of those.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Craig&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 27 Jan 2021 13:35:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/394977#M1429</guid>
      <dc:creator>Craig_Thonis</dc:creator>
      <dc:date>2021-01-27T13:35:43Z</dc:date>
    </item>
    <item>
      <title>Re: Speed up the execution of query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/395253#M1430</link>
      <description>&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As the Query recomputes every time usually it depends on the filters you are using on the data,&lt;/P&gt;&lt;P&gt;and if you really want to purge the data which already having some records and dont wants to recompute and fetch only the latest records we usually recommends to use Incremental Query.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Keerti J&lt;/P&gt;</description>
      <pubDate>Fri, 29 Jan 2021 04:13:05 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/395253#M1430</guid>
      <dc:creator>keertij82676895</dc:creator>
      <dc:date>2021-01-29T04:13:05Z</dc:date>
    </item>
    <item>
      <title>Re: Speed up the execution of query activity</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/397067#M1431</link>
      <description>Hi &lt;LI-USER uid="17406416" login="El-Coder"&gt;&lt;/LI-USER&gt;, Was any of the given solutions helpful to resolve your query? Do let us know. Thanks!</description>
      <pubDate>Mon, 15 Feb 2021 07:31:18 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/speed-up-the-execution-of-query-activity/m-p/397067#M1431</guid>
      <dc:creator>Sukrity_Wadhwa</dc:creator>
      <dc:date>2021-02-15T07:31:18Z</dc:date>
    </item>
  </channel>
</rss>

