Is data insertion is fast in SYBASE IQ if we have more
indexes on a table?
Answers were Sorted based on User's Feedback
Answer / lambertdatabase
More Index cause more time and resource.
It will be slower than no index table.
|Is This Answer Correct ?||11 Yes||1 No|
Answer / shoaib
Not at all.
it will degrade the performance.......
|Is This Answer Correct ?||4 Yes||0 No|
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|
Compare in and exists?
How would you lock a table in sybase?
How do I create a partitioned table that spans multiple devices in sybase?
How do I connect to sybase?
You need to purge data from audit database. What will you do?
What is asa in sybase?
What is table partitioning in sybase?
How do I correct time slice -201?
How can I execute dynamic sql with ase in sybase?
What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?
what is directio?
what is the architechure of sybase ASE?