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
How to pad with leading zeros an int or smallint in sybase?
Explain the advantages of sybase iq.
What is replication server in sybase?
What are the main differences between 11.x and 12.x versions of sybase?
Are you doing the updates from within a cursor?
Explain about the mainframe connect tools from sybase?
Explain table partitioning in sybase.
What is the drawbacks of normalization?
Is sybase open source?
What measures are there to increase the db space?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
Explain sybase sql server?
Why am I running out of locks on the replicate side in sybase ?
You need to multiply all values of a single column. How would you do that?
What is sybase replication server?