just wanted to know why it is not recommended to set transactions to level serializable??
Serializable is the highest level of isolation, and conversely the lowest level of concurrency - so this alone would probably stop most people from using it. Running multiple SERIALIZABLE transactions at the same time will have the effect of running them one at a time - i.e.serially.
19 People are following this question.