opc.three (10/8/2012)
PiMané (10/8/2012)
opc.three (10/8/2012)
How wide is that customerCode and is that an oft-used column to increase selectivity?Pardon my ignorance, not used to some technical terms in English, but what do you mean by "How wide is that customerCode"?
Thanks,
Pedro
Sorry, I could have said that in a better way. I meant to ask what is the data type (CHAR, VARCHAR, NCHAR, NVARCHAR) and if it is of variable-length, how wide is the data on average?
🙂 the column is NVARCHAR(20) but mostly used always 10 chars = 2 letters + 8 numbers.
But this is just a case study since other our clients can have only numbers or only chars without any pattern.
That's why it's hard to determine if the column is sequential or not... probably on 80% is sequential, starts at 000001 and goes on... In this case the column would be a very good cluster index...
When we don't know how the clustered index column(s) will be filled is there any FILLFACTOR value appropriate or every case is a different one?
Thanks,
Pedro