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 |
Alternative to row at a time processing in sybase?
What are the advantages that you can get from mainframe connect in sybase?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
Explain procedure cache and data cache in sybase.
How to save space when inserting rows monotonically?
How do you use workspace in sybase?
What is the use 'return' keyword in Stored Procedure?
What is replication server in sybase?
What is a good example of a transaction in sybase?
What is sybase used for?
What are table partitions? How is it different with ase 15.0 version?
What are the vital features of sybase?
Oracle (3259)
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)