Question

test 123 test test 324 test 123 test test 324 test 123 test test 324 test 123 test test 324 test 123 test test 324 test 123 test test 324

Answer 1

Updating a table with indexes takes more time than updating a table without (because the indexes also need an update). So, only create indexes on columns that will be frequently searched against.

Answer 2

The syntax for creating indexes varies among different databases. Therefore: Check the syntax for creating indexes in your database.