Partition in Sybase
Is it possible that two tasks be assigned to the similar Partition in Sybase?
Expert
Yes, it is possible that the two tasks be assigned to the similar Partition in Sybase. ASE arbitrarily assigns partitions. This means that there is always a chance that the two users will vie for the similar partition when attempting to insert and one would lock the other out.
The more partitions a table consists, the lower the probability of users trying to write to similar partition at similar time.
Write down brief note on the issues for database performance?
Specify the difference between the ER Modeling and Dimensional Modeling?
Clarify briefly why dimension tables is de-normalized in the nature?
How would the developer describe variable by using referential data types?
State the difference between OLTP and OLAP?
Write down the differentiation between view and materialized view?
What is BCA? Discuss its features?
Briefly explain the sequence clustering algorithm?
Define the RETURN statement.
Describe some of the chrematistics of good data definitions.
18,76,764
1928968 Asked
3,689
Active Tutors
1459059
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!