There is a call center application that repetitively sends tactical queries to Vantage These queries use a few small tables that are joined on the primary index column.
The following maps are defined in the system:
TD_GlobalMap -
TD_Map1 -
TD_DataDictionaryMap -
TD_1AmpSparseMap_1Node -
What can be done to optimize these queries?