Why place tempdb and log on low numbered devices?



Why place tempdb and log on low numbered devices?..

Answer / Kamal Kant Verma

Placing temporary database (tempdb) and transaction logs on low-numbered devices in Sybase improves performance by reducing the seek time for these files, as they are frequently accessed during database operations. Lower numbers correspond to faster storage units.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Sybase Interview Questions

Can I partition any table in sybase ?

1 Answers  


What is raid and sybase?

1 Answers  


How to start sybase database in windows?

1 Answers  


How do you troubleshoot if your tempdb gets filled

13 Answers   HCL,


what is update statistics in sybase?

1 Answers  


What is the depth of triggers?

1 Answers  


What is a temp table? how to denote temp table?

4 Answers   Oracle,


You need to remove the affected rows and dashes. How would you do that?

1 Answers  


What do you mean by mainframe connect tool in sybase?

1 Answers  


There is no space in file system and you need to take a back up. What will you do?

1 Answers  


What are Magic Tables?

4 Answers   TCS,


How do I create a partitioned table that spans multiple devices in sybase?

1 Answers  


Categories