Glossary

Inline LOB trade-offs:

Pro: Eliminates additional I/O for small LOBs. Row retrieval is a single page read. - Pro: Improves sequential scan performance for tables with many small LOBs. - Con: Increases average row size, reducing rows-per-page for the base table. - Con: Buffer pool pages contain LOB data, which may not be t

Learn More

Related Terms