unique records and performance with combined fields
Hi all,
Just wondering, I am trying to create a performant application for a 600 mln record dataset. We already reduced the number of columns, but now I want to speed up QV by reducing the number of unique records within a field. Problem is that the end user would like to see combined fields like 01/DDFFGG where I want to split 01 and DDFFGG. How would you solve this?
a variable in the front which combines them so you don't have the unique values in the database
