tree 0b1b624040069805be1a61c79ff842bc66bac614
parent 81f916b7d38ea9d78a398ccd2e70a0651973d594
author Ankush Menat <ankush@frappe.io> 1686909400 +0530
committer GitHub <noreply@github.com> 1686909400 +0530
gpgsig -----BEGIN PGP SIGNATURE-----
 
 wsBcBAABCAAQBQJkjDHYCRBK7hj4Ov3rIwAAp7cIAH8rAL+T7VjdIcSxEPA22OlI
 CkWGbqv26cQktEX6dAslVvAACLUFPQdRBYwI6nfPIJn5Z34r47Z4XOyBdMTf8jao
 130cKAN8nIyEsZRkOdbtmqx0mOVIbI6ZVq3LsgNY+PXHjo2JEMKAhvtD1BUFNMU2
 CyHHIVXWDMEMxVh4j0cnO+STUwGAliFyk+5UYILltbbQc0onzRv77LlArZotYipK
 bgALQVMC9tUsPISi2wExEGo1BfpQxh/6XgGknZlJonTz6augSBDScrewM7ODd2jQ
 nKPhrJ5mj3g8yG9kEJ5SZQn/PLskEhk914812y7E2zUlVt0LfJbfDX7wYLIDL5I=
 =gjGW
 -----END PGP SIGNATURE-----
 

perf: Index pick list field in stock entry and DN (#35738)

We check if pick list is created against them but there's no index so we
end up reading entire table.

```
+------+-------------+------------------+-------+---------------+----------+---------+------+--------+-----------+----------+------------+-------------+
| id   | select_type | table            | type  | possible_keys | key      | key_len | ref  | rows   | r_rows    | filtered | r_filtered | Extra       |
+------+-------------+------------------+-------+---------------+----------+---------+------+--------+-----------+----------+------------+-------------+
|    1 | SIMPLE      | tabDelivery Note | index | NULL          | modified | 9       | NULL | 207015 | 348940.00 |   100.00 |       0.00 | Using where |
+------+-------------+------------------+-------+---------------+----------+---------+------+--------+-----------+----------+------------+-------------+
```

After

```
+------+-------------+------------------+------+-----------------+-----------------+---------+-------+------+--------+----------+------------+------------------------------->
| id   | select_type | table            | type | possible_keys   | key             | key_len | ref   | rows | r_rows | filtered | r_filtered | Extra                         >
+------+-------------+------------------+------+-----------------+-----------------+---------+-------+------+--------+----------+------------+------------------------------->
|    1 | SIMPLE      | tabDelivery Note | ref  | pick_list_index | pick_list_index | 563     | const | 1    | 0.00   |   100.00 |     100.00 | Using index condition; Using w>
+------+-------------+------------------+------+-----------------+-----------------+---------+-------+------+--------+----------+------------+------------------------------->
```