>Hello all, I have a quick question. If an index is built with collate = to something other than machine and you want to change collate to machine, do you have to delete the index and create it again with collate = 'machine' or can you just set collate = 'machine' and then rebuild the index? Thanks for the help.
>

You have to delete an index and recreate it in order to change collation sequence.