if used the Citation style is SWS;
Retrieval of data in SQL can be sped up by the creation of indexes in a table. Explain what an index is and how it works in speeding up data retrieval. Describe one issue that can occur by using too many indexes in a table.
Separately respond to a classmate:
Classmate Post (Erin):
“A SQL index is used to retrieve data from a database very fast. Indexing a table or view is, without a doubt, one of the best ways to improve the performance of queries and applications. A SQL index is a quick lookup table for finding records users need to search frequently.” -Bojan Petrovic. Indexes work in speeding up data retrieval by eliminating the need to examine each piece of data manually (which is very time-consuming) and allowing us to add a ‘tag,’ if you will, to each piece of data upon entry. Then, when I’m searching for a particular piece of information my index will retrieve what I’m searching for according to the tags assigned at data entry. However, an overload of these tags can be counterproductive, as they consume memory. Too many indexes can slow data retrieval.