Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Mnesia, select and secondary indexes

Tags:

erlang

mnesia

I created indexes for table and have a question. Does mnesia:select use secondary indexes?

like image 436
Kirill Trofimov Avatar asked Nov 26 '25 16:11

Kirill Trofimov


1 Answers

from http://www.erlang.org/doc/efficiency_guide/tablesDatabases.html

There are exceptions when the complete table is not scanned, for instance if part of the key is bound when searching an ordered_set table, or if it is a Mnesia table and there is a secondary index on the field that is selected/matched.

like image 87
ppolv Avatar answered Nov 28 '25 09:11

ppolv



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!