A rule of thumb for choosing indexes for a relational database includes which of the following?

Indexes are more useful on smaller tables.
Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
Do not specify a unique index for the primary key of each table.
Be careful indexing attributes that have null values.

LohaHridoy

5 views

2025-01-04 04:42

1 Answers

AhmedNazir

Answer: Option 4

Let'

5 views Answered 2022-09-01 13:21

Related Questions

Which of the following is not a relational database?

1 Answers 5 Views

Which of the following is not characteristic of a relational database model?

1 Answers 9 Views

Which language has recently become the de-facto standard for interfacing application programs with relational database system?

1 Answers 5 Views

In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.?

1 Answers 5 Views

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.?

1 Answers 11 Views

Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.?

1 Answers 5 Views

Which of the following database activities allow for the actual retrieval and use of a database?

1 Answers 4 Views

A distributed database has which of the following advantages over a centralized database?

1 Answers 8 Views

Which of the following is true for a relational database?

1 Answers 5 Views

Which of the following are objective database and not a relational database?

1 Answers 6 Views

এক্সাম দিয়ে মেধা যাচাই করুন

Job Preparation (1125)

Admission (754)

এসএসসি (10)

এইচএসসি (5)