Rahul Chopra wrote:

Hello,

I was just curious, what happens behind the scenes when an index is created in MonetDB? Indexes are created on the fly when needed in the evaluation of queries and kept as long as the deem relevant. Not made persistent either. Therefore, the response is indeed instantaneous.

I noticed it is instantaneous... just wondering why. Is the BAT file reordered (for a single column index) kind of like for a clustered index, or is a separate index created?

Thanks,

Rahul

= Truelife Financial Get the loan you deserve today regardless your credit history. http://a8-asy.a8ww.net/a8-ads/adftrclick?redirectid=cc5aa117b4038bf76c9b23dc...