What will happen if we create more indexes on a sysbase iq
table?
Answer Posted / siddardh
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 |
Post New Answer View All Answers
Explain update statistics.
State some of the products of sybase?
How do I connect to sybase?
Differentiate between db-lib and ct-lib?
How do I bcp null dates in sybase?
What do you mean by asa in sybase?
Can I run any transact-sql command on a partitioned table in sybase?
Explain about the sybase group?
A single operation is failing to escalate?
What is the difference in storage type of numeric and decimal data types in sybase ?
What are the important features of sybase?
List different types of locks in sybase?
How do I open a sybase database?
How do I configure identities in sybase?
How would you replicate col = col + 1 in sybase?