# Remove the Bindings - Example

```
tidb> ~!@DROP BINDING FOR@!~ SELECT * FROM employees, salaries WHERE employees.emp_no = salaries.emp_no;
Query OK, 0 rows affected (0.00 sec)

tidb> SHOW BINDINGS;
Empty set (0.00 sec)

tidb> EXPLAIN SELECT * FROM employees, salaries WHERE employees.emp_no = salaries.emp_no;
+-------------------------+------------+-----------+-----------------+--------------------------------------------------------------------------+
| id                      | estRows    | task      | access object   | operator info                                                            |
+-------------------------+------------+-----------+-----------------+--------------------------------------------------------------------------+
| MergeJoin_8             | 2825288.58 | root      |                 | inner join, left key:db1.employees.emp_no, right key:db1.salaries.emp_no |
| ├─TableReader_32(Build) | 2844047.00 | root      |                 | data:TableFullScan_31                                                    |
| │ └─TableFullScan_31    | 2844047.00 | cop[tikv] | table:salaries  | keep order:true                                                          |
| └─TableReader_30(Probe) | 300024.00  | root      |                 | data:TableFullScan_29                                                    |
|  └─TableFullScan_29     | 300024.00  | cop[tikv] | table:employees | keep order:true                                                          |
+-------------------------+------------+-----------+-----------------+--------------------------------------------------------------------------+
5 rows in set (0.00 sec)
```

------------------------------------------------------------------------------
We can delete existing bindings as follows:

```
tidb> DROP BINDING FOR SELECT * FROM employees, salaries WHERE employees.emp_no = salaries.emp_no;
Query OK, 0 rows affected (0.00 sec)

tidb> SHOW BINDINGS;
Empty set (0.00 sec)

tidb> EXPLAIN SELECT * FROM employees, salaries WHERE employees.emp_no = salaries.emp_no;
+-------------------------+------------+-----------+-----------------+--------------------------------------------------------------------------+
| id                      | estRows    | task      | access object   | operator info                                                            |
+-------------------------+------------+-----------+-----------------+--------------------------------------------------------------------------+
| MergeJoin_8             | 2825288.58 | root      |                 | inner join, left key:db1.employees.emp_no, right key:db1.salaries.emp_no |
| ├─TableReader_32(Build) | 2844047.00 | root      |                 | data:TableFullScan_31                                                    |
| │ └─TableFullScan_31    | 2844047.00 | cop[tikv] | table:salaries  | keep order:true                                                          |
| └─TableReader_30(Probe) | 300024.00  | root      |                 | data:TableFullScan_29                                                    |
|  └─TableFullScan_29     | 300024.00  | cop[tikv] | table:employees | keep order:true                                                          |
+-------------------------+------------+-----------+-----------------+--------------------------------------------------------------------------+
5 rows in set (0.00 sec)
```

We have removed the execution plan binding for the query `SELECT * FROM employees, salaries WHERE employees.emp_no = salaries.emp_no;`. This means the optimizer will revert to using the previous `MergeJoin` method for table joins.