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 do you understand by the term concurrency control in DBMS?
Briefly describe time series algorithm in data mining?
Specify the user profiles within the Supervisor?
Explain the operations that can be done with the Data Stage Director?
Write a brief note on the market basket analysis?
Describe the three types of data sources which are used with ODBC?
Write down the unsupported repository objects for mapplet?
Should I use numerous devices to take benefit of Partitions in Sybase?
Illustrate the term audio data mining.
Write a short note on the difference between a dynamic and materialized view?
18,76,764
1942991 Asked
3,689
Active Tutors
1419981
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!