What will happen if we create more indexes on a sysbase iq
table?
- 1 Answers
- 6532 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 |
What is trace flags — 5101 and 5102 in sybase?
A single operation is failing to escalate?
How do I add a sybase driver to sql developer?
What is my identity burn factor vulnerability right now in sybase?
How would you lock a table in sybase?
What is a temp table? how to denote temp table?
What is sybase? What are its important features?
Explain 'forcing an index' concept.
Does table partitioning require user-defined segments in sybase?
Explain index covering? List its merits.
How can I tell the datetime my server started?
Explain the role of replication server 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)
