-Using indexes for predicates does not increase performance.
Mahsa Mofidpoor 2012-05-23, 00:11
I did a simple experiment to see the performance difference between normal
execution of a query and the index-based execution. However, the response
time in non-indexed approach is astonishingly smaller. Is it because of the
small data size or the single setup node I use?
I appreciate any help.
Intel(R) Core(TM) i5-2400 CPU @ 3.10GHz
Hadoop 0.20.2 (*Single setup node*)
table size ranges from 4MB to 100MB
query: select * from table1 where col1='Mark';
Chinna Rao Lalam 2012-05-23, 05:19