Interested to Buy Any Domain ? << Click Here >> for more details...
What will happen if we create more indexes on a sysbase iq
table?
- 1 Answers
- 7247 Views
- I also Faced
- E-Mail Answers
Answer Posted / siddardh
As far as i know the retrieval is fast.
as per the standard definitions the insertion will be slow.
To achieve more performance when you are loading large data
please drop indexes on the table and load the data.Once your
load has completed recreate indexes.
It will help your performance.
Please correct me if i am wrong?
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Explain 'forcing an index' concept.
Explain the difference between numeric and decimal data types in sybase.
What is ceiling()?
List similarities and differences between oracle & sybase.
There is no space in file system and you need to take a back up. What will you do?
For synchronizing the logins from lower version to higher version, just take the 11.9.2 syslogins structure, go to 12.5 higher version server?
Are you doing the updates from within a cursor?
What is the stored procedure to view current lock and processes respectively?
You need to purge data from audit database. What will you do?
Explain sybase sql server?
What do you mean by exception log in replication?
What is sybase replication server?
Tempdb is full. How would you clear it?
How do I add a sybase driver to sql developer?
How do I create a partitioned table that spans multiple devices in sybase?
