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.
Give a brief introduction of the term Virtual Data Warehousing?
Describe briefly the difference between pessimistic locking and optimistic locking?
What do you understand by the term JavaScript and VBScript in DBMS?
Explain the term Account and Directory options?
Explain the power center repository?
Illustrates the introduction about economics?
Specify various tools in the Business Objects 5.1?
Write down a short note on the difference between two and three-tier architectures?
What is an Operational Data Store?
Explain the Filter transformation?
18,76,764
1945682 Asked
3,689
Active Tutors
1453289
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!