Creating and Using Segments

This chapter introduces the system procedures and commands for using segments in databases.

See also Chapter 5, "Controlling Physical Data Placement," in the Performance and Tuning Guide for information about how segments can improve system performance.

What is a segment?

System-defined segments

Commands and procedures for managing segments

Why use segments?

Controlling space usage

Improving performance

Moving a table to another device

Creating segments

Changing the scope of segments

Extending the scope of segments

Reducing the scope of a segment

Assigning database objects to segments

Creating new objects on segments

Placing existing objects on segments

Placing text pages on a separate device

Creating clustered indexes on segments

Dropping segments

Getting information about segments

sp_helpsegment

sp_helpdb

sp_help and sp_helpindex

Segments and system tables

A segment tutorial

Segments and clustered indexes


	Expand Search