Indexes are optional structures associated with tables or clusters, and exploiting indexes to reduce scanning of data is of crucial importance

a) Describe the role of indexing in data warehousing,

b) Explain different types of indexing methods that are used in data warehousing

c) State the advantages and disadvantages of each method.

d) Provide an example for each indexing methods

e) Discuss an indexing method that you would recommend if you were a data warehouse designer.

2) What does the term Slowly Changing Dimension (SCD) mean in data warehousing. With an example, briefly describe different types of SCD and its importance in data warehousing and state their advantages and disadvantages of different types.