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 |
You need to manipulate varbinary columns in sybase. How would you do that?
How do I connect to a sybase database?
What is replication server? What is its role in sybase?
What are triggers? Why do we use them? Diff types of triggers? What are magic tables?
What are different performance tuning tools in sybase with example. How to optimize sql code in sybase server.
What is open client in sybase?
Explain the advantages of sybase iq.
What is a natural key in sybase?
You need to multiply all values of a single column. How would you do that?
What is replication server?
What is replication server in sybase?
What are Magic Tables?
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)