network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 10 months |
| seen | Dec 3 '12 at 21:31 | |
| stats | profile views | 35 |
|
May 6 |
answered | Transfer data from DB2 to Oracle |
|
Sep 26 |
revised |
How to design a database for financial bond prices? typos and grammar |
|
Sep 26 |
suggested | suggested edit on How to design a database for financial bond prices? |
|
Aug 2 |
answered | Appropriate multi-language schema, or overkill? |
|
Jul 24 |
answered | Why does ORDER BY not belong in a View? |
|
Jul 18 |
comment |
can sql generate a good plan for this procedure? @jason - you are thinking procedural. when in DB, think relational. what you are doing is a merge, so get it done via one statement. |
|
Jul 11 |
comment |
Does the partition key also have to be part of the primary key? Well, a whole lot of stuff is not a requirement. Even indexing is not a requirement! To make sense functionally, partitioning has to be done on the leading column of a candidate key. Otherwise how would the app architect use the table? |
|
Jul 11 |
comment |
Does the partition key also have to be part of the primary key? Let me clarify - The column you are partitioning is preferred to be part of a Primary Key if it is not a Surrogate Key (Identity type of key). If the PK is a surrogate key, then it should be part of a meaningful Candidate Key. As a DBA you can use anything to partition, but for the app, it has to make sense as a clean boundary. This is possible only if it is part of some sort of a candidate key. |
|
Jul 10 |
awarded | Editor |
|
Jul 10 |
revised |
Does the partition key also have to be part of the primary key? added 4 characters in body |
|
Jul 10 |
awarded | Commentator |
|
Jul 10 |
comment |
Does the partition key also have to be part of the primary key? Same as any other index. example: CREATE INDEX IX_ProductVendor_VendorID ON Purchasing.ProductVendor (BusinessEntityID); |
|
Jul 10 |
comment |
Does the partition key also have to be part of the primary key? Candidate Key is just another key qualified to be a Primary Key. For example, ID is the primary key. But in the same table, if another column for eg. PERSON_ID also can uniquely identify a row, that is called Candidate Key. The 2nd and 3rd normalization rules should hold against all candidate keys also. |
|
Jul 9 |
answered | Does the partition key also have to be part of the primary key? |
|
Jul 9 |
answered | Mechanics of partitioning |
|
Jul 6 |
answered | UPDATE with JOIN on 100mm records, how to do this better? (in T-SQL) |
|
Jul 5 |
comment |
Which mysql storage engine to choose? With Full-Text capability in 5.6, it is hard to find a compelling technical reason for not using innoDB. There may be licensing difference though. |
|
Jul 5 |
comment |
Help optimizing query in the MySQL slow-query log Good catch, blob does it |
|
Jul 5 |
answered | Help optimizing query in the MySQL slow-query log |
|
Jul 5 |
comment |
Help optimizing query in the MySQL slow-query log @Rolando, I doubt either of your suggestions would help. |
