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.
Write a short note on the difference between a dynamic and materialized view?
What is meant by the Data warehouse?
Explain what is meant by the term universe stage?
Describe briefly the term maximum and minimum cardinality?
Database Requirements Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: • Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classifie
Name the main data structures used in these areas: Hierarchical data model, RDBMS and Network data model?
Write out the disadvantages of using the Alias?
List out some of the features of a relation in DBMS?
In JDBC driver which coding pattern is use? Describe briefly?
State the benefits of the Business Objects over the other DSS?
18,76,764
1929025 Asked
3,689
Active Tutors
1432803
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!