Database Development

Is there a way to decrease the size of some indexes by trading off some precision?

I have a table that has a number of 32-bit int IDs that are used as foreign keys. The actual cardinality is under a million unique values. I want to reduce the size of these indexes so that they can all fit in a certain amount of RAM. Is there a way I can tell […]