I am new to ETL testing and dB environment.Some say PI is clustered index some say it is not. Even I found some where that secondary index is non clustered index. What is actually primary index and secondary index? When do we need primary index and when we need secondary index? If PI index and clustered index are different then how are they different?