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
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 |
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 |
What are the best monitoring tools for the sybase database?
Differentiate between db-lib and ct-lib?
Explain coalesce.
What is trace flags — 5101 and 5102 in sybase?
How can i retrieve the pseudoColumn values of a table in sybase? In oracle, we can get the same as 'ROWID'. Likewise in sybase which one is pseudo column?
How to find the time taken for rollback of the processed?
How to manually drop a table in sybase?
When are stored procedures compiled in sybase?
How do I create a partitioned table that spans multiple devices in sybase?
How do I connect to a sybase database?
How do I pipe the output of isql to a file in sybase?
What is the command for quitting from sybase?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)