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 |
Can I partition any table in sybase ?
What is raid and sybase?
How to start sybase database in windows?
How do you troubleshoot if your tempdb gets filled
what is update statistics in sybase?
What is the depth of triggers?
What is a temp table? how to denote temp table?
You need to remove the affected rows and dashes. How would you do that?
What do you mean by mainframe connect tool in sybase?
There is no space in file system and you need to take a back up. What will you do?
What are Magic Tables?
How do I create a partitioned table that spans multiple devices in sybase?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)