Basic search question

Need help Database
1

I have a table of songs and a table of songwriters.
A songwriter has a field, “notes”.

My aim is simply to generate a list of songs that shows songwriters that have a certain keywords in their note.

My current search looks like this:

Do a search for SongWriters (Constraint: Note contains “XYZ”)'s Songs:unique elements

It works - but it is very slow.

Could someone please tell me if that is the most optimal way to perform this search?

Many thanks

2

I can not imagine that there is another way, unless you already have a pre-defined list of keywords that might be searched. If you do, you can when the writer adds notes run the search to save to a field the list of keywords it contains, then your search is for that field instead of the note field, making it quicker to find I’d imagine.