Maintaining Indices

[thatcort]

Hi, how do you update indices when adding rows? I see the methods create_index() and create_scalar_index(), but it seems like these will become obsolete on every append. Are they automatically updated or is there an update method that needs to be called? Similarly, are the indices updated during table compaction?

[eddyxu]

@thatcort we have a method call optimized_indices() will append new rows into existing index fragments.