On 27 Jul 2015, at 7:34pm, Drago, William @ CSG - NARDA-MITEQ <William.Drago at L-3com.com> wrote:
> If case is not important would adding COLLATE NOCASE to column c improve > performance? Depends whether it would reduce the number of different 'chunks'. In other words whether there really were any examples of the column having more than one of 'abd' and 'Abc' or 'ABC'. But since people generally want non-case-sensitive searching when they search, it might be a good idea in any ... erm ... case. Simon.
