Of Interest
Be responsible for your future
Enter the USA legally!
Visa, Green Card, Citizenship, Passport
Consultation Services
|
Sybase
»
DDL
»
DBA
»
Tables which span multiple segments
Tables containg large amounts of data (> 2 GB) need to be spread across
several devices, using sp_placeobject. Note that this procedure affects only
future operations - if a table load of more the 2 GB is to be performed, it
would have to be split into two or more stages.
/* Future inserts will reside on data_seg2 */
sp_placeobject 'data_seg2','invoice'
go
|
|
|
Get the latest Rocket99 news and tech tips via
|
