Arcadia.io interview question

What's the pro and con about Index in SQL?