composite-key Questions

Is unique composite index as effective as non-composite for queries on first column? – Postgresql

January 22, 2023
asymmetriq
2 Answers

I have a table with b-tree index on column A (non-unique). Now I want to add a check for uniqueness of column A and column B combination when inserting, so I want to add a unique composite index (A, B).…

VIEW QUESTION

How to delete record with composite primary keys using Eloquent? – Laravel

October 5, 2022
Ruwan Liyanage
2 Answers

I'm trying to delete a record with two primary keys, using Eloquent - Laravel. This is my model class Like extends Model { //protected $primaryKey = ['crdid', 'usrid']; public $timestamps = false; use HasFactory; } Controller try{ $dellike = Like::where('crdid',…

VIEW QUESTION