I have a list of IDs for a table in CSV format.
What would be the most efficient way to retrieve a ref list?
Using SELECT with FIND function to match the table ID and the CSV text is very slow.
Is there a way to simply covert the CSV to a ref ID list without using SELECT?
@Steven_Aung If itโs a virtual column, try changing the type of the column to be a list of table refs.
User | Count |
---|---|
41 | |
29 | |
22 | |
20 | |
15 |