This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: What is query optimization? What will be an ideal response?[br][br][b][color=#7BCCB5]Question ... (Read 20 times)

roselinechinyere27m

  • Hero Member
  • *****
  • Posts: 557
on: Jul 7, 2018
What is query optimization?
 
  What will be an ideal response?

Question 2

What type of columns does a fact table contain?
 
  What will be an ideal response?


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

cpetit11

  • Sr. Member
  • ****
  • Posts: 321
Reply #1 on: Jul 7, 2018
Answer to Question 1

Query optimization refers to examining multiple ways of executing the same query and choosing the fastest option.

Answer to Question 2

A fact table contains fact-measure attributes and foreign keys that connect the fact table to the dimension tables.


roselinechinyere27m

  • Member
  • Posts: 557
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

cassie_ragen

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Great answer, keep it coming :)

« previous next »
 

Did you know?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

The human body produces and destroys 15 million blood cells every second.

Did you know?

Every 10 seconds, a person in the United States goes to the emergency room complaining of head pain. About 1.2 million visits are for acute migraine attacks.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

It is difficult to obtain enough calcium without consuming milk or other dairy foods.

Color-enhanced X-ray of the colon taken during a barium enema. Color-enhanced X-ray of the colon taken during a barium enema.
Color enhanced X ray of large malignant tumor in the right lung. Color enhanced X ray of large malignant tumor in the right lung.
Selected Biologic Response Modifiers and Miscellaneous Antineoplastics Selected Biologic Response Modifiers and Miscellaneous Antineoplastics
Biology Question Biology Question
Question 37 Part 2 Question 37 Part 2
Economics question Economics question
Video: How eudicots (true dicots) differ from monocots Animation

For a complete list of videos, visit our video library