Explain way to save space while inserting rows monotonically
Illustrates the way to save space while inserting rows monotonically?
Expert
If the columns which comprise the clustered index are monotonically rising (which is, new row key values are greater than those earlier inserted) the given System 11 dbcc tune will not split the page while it's half way full. Quite it'll let the page fill and after that allocate other page:
dbcc tune(ascinserts, 1, "my_table")
Incidentally, SyBooks is wrong when this states that the above requires to be reset while ASE is rebooted. It is a permanent setting not temporary.To undo this:
dbcc tune (ascinserts, 0, "my _ table")
What are the techniques in which an Oracle database can be created?
Describe the relationship of OLE DB, ADO, and ODBC?
define types of transaction failures and also what is meant by catastrophic failure?
Explain the transformations which are used for the variable port?
Illustrates the case statement present into stored procedure?
Write down the brief notes on multidimensional data model.
How do you inform DBPAK regarding Stored Procedure?
Explain the advantage of Table Partitioning with bcp in Sybase?
What are the drawbacks of the client or server model?
What are the improved features in Teradata V2R5/6?
18,76,764
1938598 Asked
3,689
Active Tutors
1439117
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!