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 81 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
Wow, this really help

bassamabas

  • Member
  • Posts: 294
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

Elderly adults are living longer, and causes of death are shifting. At the same time, autopsy rates are at or near their lowest in history.

Did you know?

Russia has the highest death rate from cardiovascular disease followed by the Ukraine, Romania, Hungary, and Poland.

Did you know?

On average, someone in the United States has a stroke about every 40 seconds. This is about 795,000 people per year.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Cultural Variations in the Strange Situation Across cultures, most toddlers exhibit secure attachme Cultural Variations in the Strange Situation Across cultures, most toddlers exhibit secure attachme
How to plot a sine function containing an amplitude and phase shift (Question 1 of 3) How to plot a sine function containing an amplitude and phase shift (Question 1 of 3)
Probability question Probability question
economic question economic question
economic question (having trouble) economic question (having trouble)
Question Question
Video: Body plan of euglena Animation

For a complete list of videos, visit our video library