When you use SQL statements to access tables in a database without an index configured,...

Vendor: Alibaba Cloud
Product: ACA-Operator
Update on: Jul 30, 2025
Questions: 62

Alibaba Cloud ACA-Operator Question Answer

When you use SQL statements to access tables in a database without an index configured, a full table scan will be performed. If a table contains a large amount of data, this kind of scan will access a large amount of data and consume a lot of the database's resources. Which of the following options are best practices when creating database indexes? (Number of correct answers: 3)

Add an index to a field that is frequently queried but does not frequently perform add, delete, or modify operations.

Applies indices to fields to contain many records.

A table should not contaiiAiore than 6 indexed fields.

Apply indexing to fields of fixed length (preferably not long fields).

Adhere to the rightmost prefix principle when using composite indexes