Question : If I declare a column to be serial in PostgreSql, it will auto-increment in a ordinal sequence. The […]
Tag: uniqueidentifier
Why should I create an ID column when I can use others as key fields? [duplicate]
Question : This question already has answers here: Closed 10 years ago. Possible Duplicate: Why use an int as a […]
Performance of using a non-clustered index as primary key
Question : Background I am designing a database for a record management system. It’s early stages as I am considering […]
Guid vs INT – Which is better as a primary key?
Question : I’ve being reading around reasons to use or not Guid and int. int is smaller, faster, easy to […]
Query on char with selector with N prefix is very slow
Question : I have a table with a CHAR(36) “id” column, which is a clustered primary key. It has multiple […]
Shortest Query to Combine Count and Unique (Oracle)
Question : I have the following query which works for me: select count(*) from ( select UNIQUE col1, col2, col3 […]
Purpose of IDs in a User Table Database
Question : In a table, such as a user table, where there will only be 1 row with a for […]
Is GUID(uniqueidentifier) not suitable for a clustered index? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Should I use UUID as well as ID
Question : I’ve been using UUIDs in my systems for a while now for a variety of reasons ranging from […]
How to use Unique key via combinations of table fields?
Question : Take a look at the following sqlfiddle: http://sqlfiddle.com/#!2/dacb5/1 CREATE TABLE contacts ( id int auto_increment primary key, name […]