What will happen if we create more indexes on a sysbase iq
table?
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 |
Explain the structure of adaptive server enterprise?
How to clear tempdb when the tempdb gets filled in sybase?
Explain intimate shared memory(ism)
List similarities and differences between oracle & sybase.
What is my identity burn factor vulnerability right now in sybase?
Which should I use, repagent or ltm in sybase?
What is procedure cache and data cache in sybase?
How do I move tempdb off of the master device?
How do I configure the burn factor in sybase?
Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?
How do you check database space? What measures are there to increase the db space?
What is open server in 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)