What is the difference between Composite index and join index
Is it this difference that composite index creates sub tables to store pointers to data but Join index re-distribute the entire data
Which is better to use between two
This is composite index:
You can read the material.
I am not talking about composite primary index but composite secondary index
If you have heard of covered query,it is the query where all the columns of composite index are used in the select statement
My question was about that.......Whether the covered query of the secondary index is better or the join index
Can you give me the queries for both of them and some test data, I will test and let you know.