Hi Edwin,
For these and similar question, these Mendix Docs are the place to find the answer: https://docs.mendix.com/refguide/indexes/
And for even more info the is always wikipedia to the rescue.