# `IndexLookUp` Data Aggregator, `IndexRangeScan` and `TableRowIDScan` Operators - Example

```6
tidb> EXPLAIN SELECT * FROM employees WHERE first_name IN ('Parto', 'Sumant');
+---------------------------+---------+-----------+---------------------------------------------------+----------------------------------------------------------------+
| id                        | estRows | task      | access object                                     | operator info                                                  |
+---------------------------+---------+-----------+---------------------------------------------------+----------------------------------------------------------------+
| IndexLookUp_10            | 472.87  | root      |                                                   |                                                                |
| ├─IndexRangeScan_8(Build) | 472.87  | cop[tikv] | table:employees, index:idx_first_name(first_name) | range:["Parto","Parto"], ["Sumant","Sumant"], keep order:false |
| └─~!@TableRowIDScan_9(Probe) | 472.87  | cop[tikv] | table:employees@!~                                   | keep order:false                                               |
+---------------------------+---------+-----------+---------------------------------------------------+----------------------------------------------------------------+
3 rows in set (0.01 sec)

tidb> EXPLAIN SELECT * FROM employees WHERE first_name BETWEEN 'Parto' AND 'Parzo';
+---------------------------+---------+-----------+---------------------------------------------------+-------------------------------------------+
| id                        | estRows | task      | access object                                     | operator info                             |
+---------------------------+---------+-----------+---------------------------------------------------+-------------------------------------------+
| IndexLookUp_10            | 24.15   | root      |                                                   |                                           |
| ├─IndexRangeScan_8(Build) | 24.15   | cop[tikv] | table:employees, index:idx_first_name(first_name) | range:["Parto","Parzo"], keep order:false |
| └─~!@TableRowIDScan_9(Probe) | 24.15   | cop[tikv] | table:employees@!~                                   | keep order:false                          |
+---------------------------+---------+-----------+---------------------------------------------------+-------------------------------------------+
3 rows in set (0.00 sec)

tidb> EXPLAIN SELECT * FROM employees WHERE first_name >= 'Parto' AND first_name <= 'Parzo';
+---------------------------+---------+-----------+---------------------------------------------------+-------------------------------------------+
| id                        | estRows | task      | access object                                     | operator info                             |
+---------------------------+---------+-----------+---------------------------------------------------+-------------------------------------------+
| IndexLookUp_10            | 24.15   | root      |                                                   |                                           |
| ├─IndexRangeScan_8(Build) | 24.15   | cop[tikv] | table:employees, index:idx_first_name(first_name) | range:["Parto","Parzo"], keep order:false |
| └─~!@TableRowIDScan_9(Probe) | 24.15   | cop[tikv] | table:employees@!~                                   | keep order:false                          |
+---------------------------+---------+-----------+---------------------------------------------------+-------------------------------------------+
3 rows in set (0.00 sec)
```
------------------------------------------------------------------------------
[no note]