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 choose which tables to partition in sybase?
Can two tasks be assigned to the same partition in sybase?
How do I exclude a column in sybase?
What are the important features of sybase?
Explain asa, asa ultralite.
How to view the log files in sybase?
What is the default size of master database in sybase?
Explain table partitioning in sybase.
Are there any alternatives to isql in sybase?
What is replication in sybase?
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?
What do you mean by sybase iq?
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)