What will happen if we create more indexes on a sysbase iq
table?
As far as i know the retrieval is fast.
as per the standard definitions the insertion will be slow.
To achieve more performance when you are loading large data
please drop indexes on the table and load the data.Once your
load has completed recreate indexes.
It will help your performance.
Please correct me if i am wrong?
| Is This Answer Correct ? | 20 Yes | 1 No |
How do I create a partitioned table that spans multiple devices in sybase?
How do I move tempdb off of the master device?
How do you view log files in sybase?
What are different performance tuning tools in sybase with example. How to optimize sql code in sybase server.
What are the different types of (all page) locks in sybase?
How to view the log files in sybase?
Which version of open client works with which ase in sybase?
How would you configure burn factor in sybase?
How would you fix a munged log in sybase ?
What is the relationship between jdbc and sybase?
How do I exclude a column in sybase?
What is a natural key 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)