Sybase IQ supports unique identifiers (UUIDs and GUIDs). UUIDs (universally unique identifiers) and GUIDs (globally unique identifiers) are a mechanism for uniquely identifying rows, even across distinct databases in a synchronization environment. For best performance, avoid using the unique identifiers in predicates, as these identifiers are currently supported through CIS functional compensation.