I have analyzed table FND_FLEX_VALUES, it contains thousands of values, like currency, account, etc I just started the course I think it also contains vendor, customer etc so my question is this type of structure look like slow down once table size increase, means we are going to search any value from this table will it take time in future when table size increase?
in a nutshell how you technically analyze flexfield values table and over all structure as for as performance is concern?