Video: Indexing in UniVerse - Efficiencies and Pitfalls
It is easy to add an index to a UniVerse file to increase performance, but are you aware of the system performance issues of doing this? Don’t want to wait for a select to run during month-end processing? Create a trigger. Want instantaneous retrieval of sales history based on region, date, dollar amount and phase of the moon? Create a trigger.
This session will talk about the pros and cons of adding indexes to UniVerse files, and different ways to address them.