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.
Define the Quick Sort.
What are the improved features in Teradata V2R5/6?
Write a short note on the difference between embedded and dynamic SQL?
What is meant by the term merge?
Explain the Filter transformation?
Specify the types of the tracing level?
Determine the concept of Relation Schema and a Relation?
Write about the orabulk and bcp stages?
Explain the uses of stored procedure?
Explain several of the products of Sybase?
18,76,764
1924241 Asked
3,689
Active Tutors
1416795
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!