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.
Explain what is Designer?
State the difference between the class and universe?
Explain Data Page Locking in Sybase.
Describes the main data structures used in following areas: RDBMS, Network data model and Hierarchical data model?
Explain the linked universes?
Explain the term Cognos Connection?
What do you understand by the term RFM analysis?
What is Data Manipulation Language Compiler?
Provide a brief introduction of the term cubes?
Explain the term Business Objects Repository?
18,76,764
1931815 Asked
3,689
Active Tutors
1447012
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!