# Ignore the `DEALLOCATE PREPARE`
+ To reduce the syntax parsing cost of the SQL statement within the same session
+ Option A:
  + Use `DEALLOCATE PREPARE [server side]` and `cursor.close() [protocol]` sparingly
+ Option B:
  + Ignore the commands to deallocate the prepared statement from the plan cache
  + Set `tidb_ignore_prepared_cache_close_stmt` to 1 in your session

```10
tidb> select @@~!@tidb_ignore_prepared_cache_close_stmt@!~;
+-----------------------------------------+
| @@tidb_ignore_prepared_cache_close_stmt |
+-----------------------------------------+
|                                       0 |
+-----------------------------------------+
1 row in set (0.00 sec)
```
--------------------------------------------------------------------------------

To reduce the syntax parsing cost of SQL statements, it is recommended that you run prepare statement once, then execute statement multiple times before running deallocate prepare.

We will discuss cursor shortly.

For more information please refer: https://docs.pingcap.com/tidb/dev/sql-prepared-plan-cache