3 ms·
DB performance also comes from size efficiency of user-defined data types, user-defined operator functions (typically for use with those user-defined data types
by ttfkam 4y ago
DB performance also comes from size efficiency of user-defined data types, user-defined operator functions (typically for use with those user-defined data types), etc.
Smaller, more efficient types directly translate to less disk usage and smaller indexes, both of which measurably improve database performance.
- pjmlp 4y agoI assume PL/pg is not behind the curve in relation to PL/SQL and T-SQL for UDTs.