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 means of sybase ?? and how i can use sybase data base on my computer Iam the first use it >> any help please !
Explain tds (tabular data streams).
What measures are there to increase the db space?
Compare join and subquery in performance?
What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?
Which should I use, repagent or ltm in sybase?
What is a good example of a transaction in sybase?
How do I connect to sybase?
A single operation is failing to escalate?
What is the stored procedure to view current lock and processes respectively?
How do I take advantage of table partitioning with bcp in sybase?
Explain coalesce. What is the equivalent of oracle/db2 coalesce function in sybase?