This content has been marked as final. Show 13 replies
I'm throwing this one out there for discussion. I have a feeling that I've seen it discussed before, but can't find the thread!
Regularly I will have a large table that I will then need to retrieve distinct values of dimensional fields from in order to display in selection boxes etc. This obviously impacts the load significantly as it has to load the full table each time.
Any ideas on ways to improve this process? (Flags, group by's etc.)
ps. As pointed out below - the reason for doing this is that I need a separate table that is not linked to the main table