Pls define the below terms

Database
Enthusiast

Pls define the below terms

Join index
Aggregate join index
Hash index
Value-ordered secondary, hash, or join index
Covering index