I recall Praveen mentioning a while ago that ...

[Christian_Farle]

I recall Praveen mentioning a while ago that SELECT statements run much faster if the table key is number, instead of a text string generated through UNIQUEID().

What would be the column expression to generate these unique numbers? The documentation suggests “RandBetween(numberLow, numberHigh)”, but it is not clear that this generate unique numbers in the column. Can someone confirm that this is the best approach?

[pravse]

@Christian_Farley2 I cannot recall saying that, and I don’t think (absent the context) that this would be true.

[Christian_Farle]

I must be confusing threads then. But in any case the question stands: What would be the most performant Select between a key that is made with UNIQUEID (a text string) and a key that is a straight number?

[Grant_Stead]

@Christian_Farley2 the Rand between method would work.