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 data mining and data modeling? In what manner both the termed are used?
Explain the repository domains?
Categorize the Hashing Functions based on the different methods through which the key value is found?
Illustrates the term data sparsity and how this effect upon aggregation?
States the term Sybase group.
List out the various detected patterns.
Write down the differentiation between view and materialized view?
Write down the latest error handling technique in SQL Server 2005?
Write about the orabulk and bcp stages?
define types of transaction failures and also what is meant by catastrophic failure?
18,76,764
1954238 Asked
3,689
Active Tutors
1420400
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!