[IDEA] Add option to create indexes automatically for METADATA columns to speed up searches

[anibal2j]

Is your feature request related to a problem? Please describe.
I'm copying here what I wrote in nextgenhealthcare/connect#4320

Jon Bartels asked me to add a comment to this issue here. I always thought (back from the time I took the Fundamentals course with NextGen) that custom meta data columns were indexed. I've been using custom meta data columns for ever, and I always noticed that they were slow to search. EVERY SINGLE CHANNEL that I have has two custom meta data columns:

MRN
Acc#

And this is required in my case because most of the times I get questions like:

. When did we receive the order for acc#?
. When was the last time we received an order for patient MRN #?
. How many ORMs did I get for acc# ?

I get these requests on a daily basis, multiple times per day. Right now, some of my channels have a lot of data (and I don't want to purge them - I have them set to 90 days which is enough to do my troubleshooting). Doing a search with either acc# or MRN it takes about 10", sometimes a bit more, sometimes less. It'd be great if these columns were automatically indexed so that my search would be super quick.

Describe your use case
See above. Summary is that I often have to search for messages matching either the acc# or the MRN columns, which I already have defined as METADATA. These queries happen several times a day and in very large channels the searches can take more than 10 seconds.

Describe the solution you'd like
See the issue under NG Mirth, but @pacmano1 had a good idea to expose this in the GUI itself, as an optional checkbox.

Describe alternatives you've considered
Looked at creating manual indexes, and although this has worked, it's hard to remember which channels have the index, which ones don't. Having it in the GUI would be MUCH superior.