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?



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

Answer / 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

More Sybase Interview Questions

Alternative to row at a time processing in sybase?

0 Answers  


What are the advantages that you can get from mainframe connect in sybase?

0 Answers  


What is a coalesce? What is the equivalent of oracle/db2 coalesce function in sybase?

0 Answers  


Explain procedure cache and data cache in sybase.

0 Answers  


How to save space when inserting rows monotonically?

0 Answers  


How do you use workspace in sybase?

0 Answers  


What is the use 'return' keyword in Stored Procedure?

2 Answers  


What is replication server in sybase?

0 Answers  


What is a good example of a transaction in sybase?

0 Answers  


What is sybase used for?

0 Answers  


What are table partitions? How is it different with ase 15.0 version?

0 Answers  


What are the vital features of sybase?

0 Answers  


Categories