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 56 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
Excellent

DylanD1323

  • Member
  • Posts: 314
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

There used to be a metric calendar, as well as metric clocks. The metric calendar, or "French Republican Calendar" divided the year into 12 months, but each month was divided into three 10-day weeks. Each day had 10 decimal hours. Each hour had 100 decimal minutes. Due to lack of popularity, the metric clocks and calendars were ended in 1795, three years after they had been first marketed.

Did you know?

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

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

Illness; diuretics; laxative abuse; hot weather; exercise; sweating; caffeine; alcoholic beverages; starvation diets; inadequate carbohydrate consumption; and diets high in protein, salt, or fiber can cause people to become dehydrated.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Eye Color Is a Sex-Linked Trait in Drosophila (Part 3) Eye Color Is a Sex-Linked Trait in Drosophila (Part 3)
How to use Cramer's rule to solve a second-order determinant (Question 2) How to use Cramer's rule to solve a second-order determinant (Question 2)
this is a math question this is a math question
economic question economic question
Question about Resultant of gravitational force? Question about Resultant of gravitational force?
Chem question Chem question
Video: Helper T cell receptors, activation, proliferation, differentiation & action

For a complete list of videos, visit our video library