Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What will happen if we create more indexes on a sysbase iq
table?

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


Please Help Members By Posting Answers For Below Questions

Explain update statistics.

862


State some of the products of sybase?

903


How do I connect to sybase?

879


Differentiate between db-lib and ct-lib?

974


How do I bcp null dates in sybase?

937


What do you mean by asa in sybase?

994


Can I run any transact-sql command on a partitioned table in sybase?

848


Explain about the sybase group?

916


A single operation is failing to escalate?

828


What is the difference in storage type of numeric and decimal data types in sybase ?

873


What are the important features of sybase?

981


List different types of locks in sybase?

985


How do I open a sybase database?

988


How do I configure identities in sybase?

861


How would you replicate col = col + 1 in sybase?

1057