samedi 29 novembre 2014

If a database is in memory does it still need indexing?


INFO I'm following lessons on databases. We're learning about indices now.


Question


If big parts of a table are in the memory, would using a index still have benefits?


My side


I would assume indexing makes a search always faster, so yes it would have benefits. I hope this is not to much opinion based and maybe someone have a good explained reason why or why not it has benefits.





Aucun commentaire:

Enregistrer un commentaire