Is data insertion is fast in SYBASE IQ if we have more
indexes on a table?

Answers were Sorted based on User's Feedback



Is data insertion is fast in SYBASE IQ if we have more indexes on a table?..

Answer / lambertdatabase

No way.
More Index cause more time and resource.
It will be slower than no index table.

Is This Answer Correct ?    11 Yes 1 No

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?..

Answer / shoaib

Not at all.
it will degrade the performance.......

Is This Answer Correct ?    4 Yes 0 No

Is data insertion is fast in SYBASE IQ if we have more indexes on a table?..

Answer / vinayak godse

No. it will decreased performance as increasing the Indexes because it will take time to update the each Indexes on table.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Sybase Interview Questions

How to manually drop a table in sybase?

0 Answers  


How to check database size in sybase iq?

0 Answers  


What mandatory options are required for bcp command utility?

0 Answers  


can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com

2 Answers  


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

0 Answers  






What will you do if a replication thread goes down?

0 Answers  


How does partition assignment relate to transactions in sybase?

0 Answers  


Alternative to row at a time processing in sybase?

0 Answers  


How can I improve throughput in sybase?

0 Answers  


Sybase system databases

2 Answers  


How do I choose which tables to partition in sybase?

0 Answers  


Why place tempdb and log on low numbered devices?

0 Answers  


Categories