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.
In Sybase does table Partitioning needs user-defined segments?
Explain what is meant by the repository and what does it consists of?
Explain the way to swap a db device along with other.
Give a brief introduction of the term data cleaning?
Write down brief note on the differentiation between dynamic cache and static cache?
Explain the term Cloud Computing?
Which member function places a new node on the end of the linked list? Answer: appendNode(): This member function places a new node on the end of t
Define the RETURN statement.
What is meant by star schema?
Give a brief introduction of the term dicing and slicing in business objects?
18,76,764
1949724 Asked
3,689
Active Tutors
1413812
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!