I'm trying to index my database as efficiently as possible but there are a few things I don't understand fully. First off, I know not to index too many columns. when I call up the command to show indexes from my_table there are a few columns headings I'm fuzzy on.
First one is - Seq_in_index
I noticed that every index is marked in the field as one "1". I'm assuming that somehow it would be beneficial for me to change the numbering sequece to better sort through things. Am I wrong here? If not what is the command to change the number sequence?
Second is - Cardinality
I see that I have different numbers in these fields ranging from 3 to the total amount of members I have in this particular table. Is there something I should be doing here?
Third is - Collation
Every field has an "A" in it. Something I need to do here?
Fourth and last - sub_part
When creating two of the indexes, I read that it is sometimes beneficial to do something like this.. alter table table_name add index aaa(column(10)); This supposedly makes the sorting faster.
I know these are a lot of questions but I can' seem to find anything to read that answers them clearly for me to understand. ANY help to explain this better to me would be greatly appreciated.
Lord Rogaine
