4 ms·
Some things that I'd love to see as options in rdbms: Enforced globally unique column names - natural joins on everything. Throw an exception if a query requi
by erpellan 11y ago
Some things that I'd love to see as options in rdbms:
Enforced globally unique column names - natural joins on everything.
Throw an exception if a query requires a table scan (bonus points if it printed the statement that would create the appropriate index).
Translate all update and delete statements into inserts (enforced immutable data + versioning).
- bmdavi3 11y agoFor queries returning results from a majority of rows in the table, won't a sequential table scan be faster than an index scan?
- jpitz 11y agoFor non-clustered indices, yes.
- jeremysmyth 11y agoand if the order is not important. Reordering large numbers of rows can be a very expensive operation.
- moron4hire 11y agoYou can force the last one but just dropping the delete and update permissions from your role.