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 is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?
What is open client in sybase?
What will you do if a replication thread goes down?
What will cause the size of a stored procedure to grow in sybase?
What is trace flags — 5101 and 5102 in sybase?
How would you lock a table in sybase?
Who owns sybase?
Are there any alternatives to isql in sybase?
State some of the criticism about sybase iq?
what is the difference between dbcc checkstorage and other dbcc commands
What measures are there to increase the db space?
When should I execute an sp_recompile in sybase?
Oracle (3253)
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)