python (65.1k questions)
javascript (44.2k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (12.9k questions)
Postgresql - Optimize ordering of columns in table range partitioning with multiple columns range
I am testing with creating a data warehouse for a relatively big dataset. Based on ~10% sample of the data I decided to partition some tables that are expected to exceed memory which currently 16GB
Ba...
smg77
Votes: 0
Answers: 0
How to use a composite primary key with Entity Framework from a foreign key in C#
I’ve got a large problem with an existing database and the primary key / foreign keys using Entity Framework.
It's an existing database and it is not allowed to change the database, at least not the e...
user3507211
Votes: 0
Answers: 2
How can I have my composite primar key in a junction table using sequelize?
I have a composite primary key in my table Foo, and a single primary key in Bar. When I make a junction using the belongsToMany syntax, only one primary key component shows up in the junction table (t...
Vanthys
Votes: 0
Answers: 1
Unique clustered index vs primary key
I have a table with composite primary key of 7 fields, but table is allowing duplicate entries with primary key. Later I noticed it also has Unique clustered index with 10 fields including 7 of primar...
Ashish Dubey
Votes: 0
Answers: 1