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.
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Explain briefly the term data mart?
Explain some of the ETL Tools?
What is Monopoly explain in brief?
What do you mean by the term stored procedure in the Teradata?
Illustrates each entry in the Link List called?
To implement the priority queue what is the minimum number of queues we need?
Why we use Context? And explain the LOV?
Write a brief note on the difference between data and database administration?
In which circumstance should you recompile the package body after recompiling the package requirement?
18,76,764
1953961 Asked
3,689
Active Tutors
1449179
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!