Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen if we create more indexes on a sysbase iq
table?
- 1 Answers
- 7162 Views
- I also Faced
- E-Mail Answers
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
Why am I running out of locks on the replicate side in sybase ?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
Explain tds (tabular data streams).
State some of the products of sybase?
Explain the features of sybase.
How do I capture a process s sql in sybase?
What measures are there to increase the db space?
You want to delete a table in sybase. How would you do it?
What is cis and how can I use it?
How do I set a password to be null?
How do I exclude a column in sybase?
How do I set ts role in order to run certain dbccs?
How do I configure identities in sybase?
