Question

all of the following are guidelines for better query design except: understand how indexes are used in query processing. use a lot of self-joins. write simple queries. retrieve only the data that you need.

Answer 1

All of the following about better query design are true, except B.

The query design may be defined as a visible illustration of the families, fields, and standards that the query is configured to go back. When designing a query, you may customize it to return particular information the use of particular formatting and standards. The SQL Designer permitted you to visually create, view and check SQL queries for database variables. You also can use it to discover tables, perspectives and fields available in the decided on information source. The SQL Designer may be opened with the aid of using clicking the Design button at the Enter SQL Query web page of the wizard.

Learn more about query design at https://brainly.com/question/16349023

#SPJ4