| What is true about index in SQL?
Choose the correct option from below list
(1)Indexes are special lookup tables that the database search engine can use to speed up data retrieval.
(2)Indexes are special lookup tables that the database search engine can use to speed up data deletion.
(3)Indexes can be created or dropped with an effect on the data.
(4)An index helps to speed up insert statement.
Answer:-(1)Indexes are special lookup tables that the database search engine can use to speed up data retrieval. | | |