- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi Adita,
Could you use text to describe your query instead of a screenshot?
I see 2 kind of queries and one is not relevant:
1- Primary key is not empty and Delivery Channel is Email and Address does not contain ',' and status is sent
2- Primary key is not empty and Delivery Channel is Email and Address does not contain '.' and status is sent
Only second is correct but has poor performances:
1- you'll never find a sent email with a ',' in its address as this is a forbidden caracter in email address... So you don't need to use a "does not contain" operator that is really consuming DB ressources on a such table
2- if the character to search is a ".", then the result is 0 as you'll always have this caracter in any email address
Anyway, broadlogRcp table is usually the table with the greater amounts of records in your database. Query it carefully and if performance are not relevant according to your needs, you should perhaps reduce its Purge retention delay in the deployment wizzard
Views
Replies
Total Likes