Databases

Question 1

What would happen without an index?

Answer 1

Index is a data structure that optimizes search. Absence of index make search engine do a plain scan of all elements of the table to find rows matching the predicate

Question 2

Delete duplicate values in a SQL table

Answer 2

Self join + delete where fields are equal and right id is greater the left
or
Use row_number over partition by target fields