How to set an index for the item in SET attribute [closed]

Closed 7 hours ago.

Already using index but query still slow in Mariadb

here’s my query :
`select
sum(dnpi_qty * ((so_item_qty – so_item_delivered_qty) / so_item_qty))
from

Why my LIKE query is so slow with ORDER BY keyword?

I have a simple query running in MariaDB 10.4.12:

Why my LIKE query is so slow with LIMIT keywork?

I have a simple query running in MariaDB 10.4.12: