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 18 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
Thanks for the timely response, appreciate it

duy1981999

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

« previous next »
 

Did you know?

Certain rare plants containing cyanide include apricot pits and a type of potato called cassava. Fortunately, only chronic or massive ingestion of any of these plants can lead to serious poisoning.

Did you know?

The lipid bilayer is made of phospholipids. They are arranged in a double layer because one of their ends is attracted to water while the other is repelled by water.

Did you know?

The first documented use of surgical anesthesia in the United States was in Connecticut in 1844.

Did you know?

Asthma attacks and symptoms usually get started by specific triggers (such as viruses, allergies, gases, and air particles). You should talk to your doctor about these triggers and find ways to avoid or get rid of them.

Did you know?

Prostaglandins were first isolated from human semen in Sweden in the 1930s. They were so named because the researcher thought that they came from the prostate gland. In fact, prostaglandins exist and are synthesized in almost every cell of the body.

Phobos in color by Mars Reconnaissance Orbiter - HiRISE Phobos in color by Mars Reconnaissance Orbiter - HiRISE
Question Above Question Above
Question continued Question continued
Question 37 Part 2 Question 37 Part 2
economic question economic question
i need help with this question please i need help with this question please
Video: Cavernous Sinus Larynx Middle Ear Orbit: Granulesm Animation

For a complete list of videos, visit our video library