Adding indexes in GemFire XD is similar to adding indexes to other databases. You need to keep them as few as possible because they will impact inserts and updates. You want to add just enough of them to make your queries run efficiently. Always a trade off. You really want to check the performance of your queries before and after adding any index, and you probably should measure performance of typical inserts/updates as well so that you can understand the trade-offs.
Impacts of creating index on tables in gemfire XD
Is it recommended to create index on tables in gemfire xd.what are the improvements and draw backs?
Please sign in to leave a comment.