A database index

Question

Options:
1) Increases database size
2) Decreases database size
3) Doesn't affect database size
4) Impact database size differently in different cases

Answer 1

1 and 4 :) the index will always increase the database size, but it will vary depending on field being indexed.