What factors influence the decision to create an index on a field? What are the goals of designing physical tables? [3+2]

An index is a data structure that speeds up data retrieval. However, creating an index on every field is not always beneficial. The following factors influence the decision: - If a field is frequently used in WHERE clauses, JOIN conditions, or ORDER BY/GROUP BY clauses, creating an index improves...