After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!
|
Sybase
»
DDL
»
DBA
»
Moving an object to another segment
When databases contain more segments than the usual default, it is
often necessary to move tables between segments.
/* move a table, in its entirety, to the new segment */
drop index 'employee.idx_employee'
go
create clustered index on employee (emp_id) on new_seg
go
/* leave table where it is, but future allocations go to the new segment */
sp_placeobject new_seg , 'employee'
go
/* leave table where it is, but future allocations for the
text column (employee_notes) go to the new segment */
sp_placeobject new_seg , 'employee.temployee_notes'
go
|
|
|
|
