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.
Elucidate briefly what is batch and also give explanation about the types of batches?
Illustrates the two tasks to be assigned to similar partition in Sybase?
In what manner SAS so well-liked?
Illustrates the term Monopolistic Competition?
Give a brief introduction of the term universe in SQL? Brief explain the kinds of universes in business objects?
Explain the Aggregate Awareness?
Explain Triggers and Rules?
Why is modeling time-dependent data important with a time stamp?
Name the methods that are available in storing sequential files?
Explain terms Data Cache in Sybase. Answer: It is the memory area where data which is required for the current queries running is bought by Disk upon to memory for
18,76,764
1933194 Asked
3,689
Active Tutors
1440544
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!