sorry for my english.
I have a particular question:
i have a this structure bucket:
and in this bucket there are 170,00 documents.
For search a specific filename i use the Full Text Indexes (is perfect solution).
But the problem is if i want to search a inside part of filename.
If i make a query like this:
“SELECT *` FROM bucket_name WHERE filename LIKE ‘%text%’”
the execution time is about 8 seconds.
Then i think to use the indexs, but I can not think of how to structure them.
Have you any idea?