Læse, opdatere, indsætte, slette - hvad kræver mest?

mest opdatere
mindst læse

vil jeg tro

Det kommer an på om du har indekser. Indekser sløver indsættelse/opdatering, men effektiviserer en læsning (søgning).

Ok, så hvad er svaret, hvis jeg oplyser, at der altid indekseres?

If you just READ a record then once the record is found then thats it. If you want to UPDATE a record then you have to find a record and then alter the data and MAYBE alter indexes.
INSERT needs to write the record and also index's and DELETE has to find and remove the data and alspo update index's.

So I would also say that ANY operation where writes have to be done ARE going to cost more than just a read.
Exactly which operation out of (UPDATE, INSERT, DELETE) are the slowest I wouldnt know but at a guess I would say UPDATE, INSERT then DELETE.

Tak/Thanks :)