# Optimizations For Point Get

+ definitions
  + SELECT, UPDATE, DELETE on a single table
  + Scans only 1 or 0 rows of the table, and the filter condition is an equivalent query
  + The number of records return is 1 row or 0 row
+ Reason for optimization
  + The optimization method is relatively single
  + Most frequently used (OLTP)
+ How to optimize
  + Skip the logical and physical optimizations below and push down to the SQL executor
```
SELECT id, name FROM emp WHERE id = 1001;
UPDATE emp SET name = 'Jim' WHERE id = 1001;
DELETE FROM emp WHERE id = 1001;
```
------------------------------------------------------------
- What is a point get
  - For example:
    - SELECT id, name FROM EMP WHERE id = 1001;
    - UPDATE emp SET name = 'Jim' WHERE id = 1001;
    - DELETE FROM EMP WHERE ID = 1001;
  - SELECT/UPDATE/DELETE operations for single tables
  - Scans only 1 or 0 rows of the table, and the filter condition is an equivalent query
  - The number of records return is 1 row or 0
- Why do you want to optimize for point gets
  - The optimization method of the check itself is relatively single. Generally, the point query is optimized by index, and there is no need for logical optimization or physical optimization
  - Lookup is the most common and most frequently used query in OLTP systems
- What optimizations have been made to point gets
  - Skip the logical and physical optimizations below and push down to the SQL executor