DBA > Job Interview Questions > Sybase Interview Questions and Answers

Must I Use Multiple Devices to Take Advantage of

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Must I Use Multiple Devices to Take Advantage of Partitions in Sybase?

It depends on which type of performance improvement you want.

Table partitioning improves performance in two ways: primarily, by decreasing page contention for inserts and, secondarily, by decreasing i/o contention. "What Is Table Partitioning?" explains each in detail.

If you want to decrease page contention you do not need multiple devices. If you want to decrease i/o contention, you must use multiple devices.

(Continued on next question...)

Other Job Interview Questions