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 74 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
:D TYSM

scikid

  • Member
  • Posts: 300
Reply 3 on: Yesterday
Wow, this really help

« previous next »
 

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

The tallest man ever known was Robert Wadlow, an American, who reached the height of 8 feet 11 inches. He died at age 26 years from an infection caused by the immense weight of his body (491 pounds) and the stress on his leg bones and muscles.

Did you know?

Intradermal injections are somewhat difficult to correctly administer because the skin layers are so thin that it is easy to accidentally punch through to the deeper subcutaneous layer.

Did you know?

Women are 50% to 75% more likely than men to experience an adverse drug reaction.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

A stallion exhibiting the characteristics of a Flehmen response A stallion exhibiting the characteristics of a Flehmen response
Clock Trig Question Clock Trig Question
Question 37 Part 2 Question 37 Part 2
this is a math question this is a math question
Dark Blue Eye Color Dark Blue Eye Color
Color-enhanced electron micrograph of a DNA replication bubble and replication forks Color-enhanced electron micrograph of a DNA replication bubble and replication forks
Video: Non-specific disease resistance mechanisms & Skin's defense barriers

For a complete list of videos, visit our video library