What will happen if we create more indexes on a sysbase iq
table?
- 1 Answers
- 6517 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
Explain asa, asa ultralite.
Explain the role of replication server in sybase.
How can I improve throughput in sybase?
How to start sybase database in windows?
What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
What is replication server in sybase?
You need to remove the affected rows and dashes. How would you do that?
How to fix a munged log in sybase?
Why place tempdb and log on low numbered devices?
What is ceiling()?
Is sybase a database? Explain.
What mandatory options are required for bcp command utility?
Which should I use, repagent or ltm in sybase?
Differentiate between ltm and repagent?
Explain data cache?
