A place to start, the AEP AI Assistanthttps://business.adobe.com/products/sensei/ai-assistant.htmlPrompt: list which attributes are not being used in segments Answer:Based on your question, here is the crafted query:Finds the attributes that are not being used in any segments. The query is limited t...
@yuhuisg I hear you.
A few things that sometimes help:
Add a Batch_ID to WHEREReplace
SELECT * withSELECT [field1], [field2], [field3], [field4]
Keep your LIMITIf you know you have a long running query, use CTAS
Hope that helps a little.