1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Afina-wow [57]
3 years ago
13

Given the following SQL Query, which columns would you recommend to be indexed? SELECT InvoiceNumber, InvoiceDate, Invoice_Total

, Invoice_Paid, Invoice_Total - Invoice_Paid as Balance FROM Invoice WHERE Invoice_Date >= "2015-07-20" and Salesman_Id = "JR" ORDER BY DESC Invoice_Total Drag the correct answers to one of the three pockets.
Computers and Technology
1 answer:
dsp733 years ago
4 0

Answer:

Invoice_Date and Salesman Id

Explanation:

As the WHERE clause looking at the Invoice_Date and Salesman Id columns so they should be indexed for the following reasons.

  • Uniquely identifiable records are guaranteed by the unique indexes in the database.
  • Data can be quickly retrieved.
  • The usage of indexes results in much better performance.
  • It can help with quick presorted list of records.
You might be interested in
What prefix describes a mass that is 1000 times smaller than a gram
yanalaym [24]
Milli as in milligram
4 0
3 years ago
Read 2 more answers
20 points fun challenge!!! Can u solve this challenge? Find the only spelled out word in this jumble of letters, there is only o
densk [106]

Answer:

hello

Explanation:

8 0
4 years ago
Read 2 more answers
An email message containing a warning related to a non-existent computer security threat, asking a user to delete system files f
LenKa [72]

Answer: Virus Hoax

Explanation:

A computer virus hoax is a message that warns someone of a false virus threat. It is a a chain email that encourages who ever has received the message to pass it to other people as a form of warning.

5 0
3 years ago
What happens when a filter is applied to a database?
Genrish500 [490]
Hello there.

<span>What happens when a filter is applied to a database?

</span><span>Some records are permanently removed from the database.
</span>
5 0
3 years ago
Which is the 6-by6 rule for presentations
marin [14]

Answer:

You might already be familiar with the 6×6 rule. This presentation rule suggests that you should include no more than six words per line and no more than six bullet points per slide. The goal is to keep your slide from being so dense and packed with information that people don't want to look at it

7 0
4 years ago
Other questions:
  • Describe the difference between public and private IPv4 addresses. If a network is using private IP addresses, how can the compu
    13·1 answer
  • : What is the difference between the Audio Mixer and the<br> Audio Meters Panel?
    7·2 answers
  • Which of the following represents the TCP/IP four-layer reference model? Group of answer choices Application, Internet, transpor
    11·1 answer
  • ammy's Seashore Supplies rents beach equipment such as kayaks, canoes, beach chairs, and umbrellas to tourists. Write a program
    13·1 answer
  • How does the actual amount left to spend differ from the budgeted amount for the remaining three months of the project?
    12·1 answer
  • A commuter swipes a public transport card at a kiosk and sees his account balance displayed on the screen. The commuter would be
    8·1 answer
  • Please can someone help my assignment.​
    13·1 answer
  • Which of these examples demonstrate portfolio income?
    13·2 answers
  • 1. It is one way to attain one's holistic health condition.​
    9·1 answer
  • In the Business world people are often measured by their???
    14·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!