What will happen if we create more indexes on a sysbase iq
table?



What will happen if we create more indexes on a sysbase iq table?..

Answer / 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

More Sybase Interview Questions

Using large raw partitions with replication server on unix in sybase?

0 Answers  


What is the difference between db-lib and ct-lib in sybase?

0 Answers  


Is sybase a database? Explain.

0 Answers  


Is sybase relational database?

0 Answers  


What causes re-resolution of a stored procedure in sybase?

0 Answers  






What will cause the size of a stored procedure to grow in sybase?

0 Answers  


Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

0 Answers  


We have lost the sa password, what can we do?

0 Answers  


How would you lock a table in sybase? What text command will you use for it?

0 Answers  


Why do my page locks not get escalated to a table lock after 200 locks?

0 Answers  


How do I open a sybase database?

0 Answers  


Are there any alternatives to isql in sybase?

0 Answers  


Categories