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

How to pad with leading zeros an int or smallint in sybase?

895


Explain the advantages of sybase iq.

947


What is replication server in sybase?

896


What are the main differences between 11.x and 12.x versions of sybase?

884


Are you doing the updates from within a cursor?

1156


Explain about the mainframe connect tools from sybase?

974


Explain table partitioning in sybase.

974


What is the drawbacks of normalization?

1017


Is sybase open source?

927


What measures are there to increase the db space?

961


What you need to do is issue an ase kill command on the connection then un-suspend the db?

978


Explain sybase sql server?

1005


Why am I running out of locks on the replicate side in sybase ?

1097


You need to multiply all values of a single column. How would you do that?

922


What is sybase replication server?

1045