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 | |
36 | |
28 | |
23 | |
16 |