What will happen if we create more indexes on a sysbase iq
table?
- 1 Answers
- 6509 Views
- I also Faced
- E-Mail Answers
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 can I execute dynamic sql with ase in sybase?
List the types of locking?
Compare in and exists?
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 will you do if a replication thread goes down?
What command helps you to know the process running on this port, but only su can run this command?
List similarities and differences between oracle & sybase.
Explain about the sybase group?
What is the use of 'with check' option in views?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
What is a natural key in sybase?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
