HBase (Easy): How to Perform Range Prefix Scan in hbase shell
So it turns out to be very easy. The scan ranges are not inclusive, the logic is start <= key < end. So the answer is scan ‘mytable’, {STARTROW => ‘abc’, ENDROW => ‘abd’}
database-scan
Why does PostgreSQL perform sequential scan on indexed column?
If the SELECT returns more than approximately 5-10% of all rows in the table, a sequential scan is much faster than an index scan. This is because an index scan requires several IO operations for each row (look up the row in the index, then retrieve the row from the heap). Whereas a sequential scan … Read more