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
AlexFokin [52]
2 years ago
6

What is an index? What are the advantages and disadvantages of using indexes? How do you use SQL to create an index?

Computers and Technology
1 answer:
damaskus [11]2 years ago
4 0

Answer:

In DBMS, an index is a physical structure that stores the values for a specific column in a table. An index can be used to extract specific information from data and access records within a table more quickly without having to scan the whole table.

An Index can be made up of one or more columns of a table and each index maintains a list of values within that field that are sorted in ascending or descending order. Indexes cannot be seen by the users, but they are just used to speed up the queries and improve the performance of a database application

You might be interested in
What size hard disc is recommended for powerpoint writting
mixas84 [53]

Answer:

Depends on how many PowerPoint files you want to store and how long they are. I'd recommend at least a 256GB hard drive to store your OS and software and then leave space for PowerPoints.

5 0
3 years ago
Como afecta la robotizacion en las empresas?
kirill [66]

Yo llamaria a esto automatizacion.

Puede reducir los costos al permitir que la empresa emplee a menos personas.

8 0
3 years ago
Complete the sentence.
julsineya [31]

Answer:

An internal server error

5 0
3 years ago
What type of websites, which let users share personal stories and photos, became popular in the 2000s?.
Lina20 [59]

Answer:

MMORPGS was a type of website that let users share their stories and pics across the world wide web

Explanation:

8 0
2 years ago
What output will the LOOKUP rmula below produce in relation to the following table?
Lana71 [14]

Answer:

The correct answer is (C)-Rainly

Explanation:

The following data is given in this question

Column A    Column B

3.25             Clear

3.91              Cloudy

4.23             Windy

4.67              Rainy

5.12               Snowy

5.98              Sunny

As we know that the Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array.

The use of lookup function is given below

LOOKUP(4.67,A1:A6,B1:B6)

When you execute this function on the given ranges , then it display "Rainly" as a result.

Furthermore, the complete example is attached with this solution

3 0
3 years ago
Other questions:
  • Are mechanical keyboards more expensive than membrane keyboards?
    9·2 answers
  • Why is the wizard able to install the printer when an actual print device is not connected to the computer??
    11·1 answer
  • What is an advantage and disadvantage to file compression
    8·1 answer
  • What are the components inside the case typically draw power from a cable connected to the motherboard instead of being connecte
    6·2 answers
  • Once you record your audio and click ok to save it what happens to the recording?
    9·1 answer
  • Anybody know this? Read the following scenario. Using complete sentences, explain which part of the CIA triad has been broken. M
    11·1 answer
  • Help me with this please​
    8·1 answer
  • Can you see the processing step yes or no
    8·2 answers
  • Write a program that calculates an adult's fat-burning heart rate, which is 70% of 220 minus the person's age. Complete fat_burn
    14·1 answer
  • Based on Microsoft's Component Object Model (COM), _____ is database middleware that adds object-oriented functionality for acce
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!