Explain the way to select tables for partition in Sybase
Explain the way to select tables for partition in Sybase?
Expert
You must partition heap tables which have large amounts of concurrent insert activity. Because, a heap table is a table, which no clustered index. Now here are some illustrations:
1. An "append-only" table to that every transaction should write2. A tables which provide a history or say audit list of activities3. A new table in which you load data along with bcp in. When the data is loaded in, then you can unpartition the table. It allows you to create a clustered index upon the table, or give other commands not permitted upon a partition table.
States the term Mirror Activator Disk mirroring?
Describe briefly Aggregate transformation?
Write a brief note on the market basket analysis?
Why is the multi value or multicolumn problem any other type of the multivalued dependency problem?
How can we remove duplicate rows from the flat file?
Write down the snapshot with reference to data warehouse?
Justify whether all the Business Objects users build the data providers?
Illustrates the about Data Manipulation Language?
What is meant by the data modelling?
State the different types of the folders?
18,76,764
1938214 Asked
3,689
Active Tutors
1428524
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!