indexing - Choosing data.table keys in R -
how choose right keys data.table objects?
are considerations similar rdbmss? first guess have documentation indexes , keys rdbmss. google came helpful stackoverflow question related oracle.
do considerations answer apply data.tables? perhaps exception of relating update, insert or delete type statements? i'm guessing our data.tables objects won't used in way.
i'm trying head around stuff using documentation , examples, haven't seen discussion on key selection.
ps: @crayola pointing me toward data.table package in first place!
i not sure helpful answer, since mention me in question i'll think anyway. remember bit of data.table newbie myself.
i use keys when there clear benefit it, e.g. merging datatables, or seems clear doing speed things (e.g. subsetting repeatedly on variable). knowledge, there no real need define keys @ all; package faster data.frame without keys.
Comments
Post a Comment