How can I partition any table in Sybase
How can I partition any table in Sybase? Explain.
Expert
No, you cannot partition any table in Sybase. There are some kinds of tables where you cannot partition:
1. Tables along with clustered indexes (like release 11.5 this is possible to have a clustered index upon a partitioned table)2. Adaptive server enterprise system tables3. Work tables4. Temporary tables5. Tables which are already partitioned. Nonetheless, you can unpartition and after that re-partition tables to modify the number of partitions.
What do you understand by the term RFM analysis?
Illustrates the difference between a file server and database server?
Which data providers can be combined in one report?
Define the CYCLE/NO CYCLE into a Sequence.
Describe briefly three types of binary relationships in DBMS?
Explain Data Only Page Locking in Sybase.
Which efficient data structure is used in RDBMS, for internal storage representation?
Give a brief introduction of the term non-additive facts?
Explain about the Database.
Describe the relationship among entity, entity class, and entity instance.
18,76,764
1937385 Asked
3,689
Active Tutors
1457039
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!