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

How do I create a partitioned table that spans multiple devices in sybase?

0 Answers  


How do I move tempdb off of the master device?

0 Answers  


How do you view log files in sybase?

0 Answers  


What are different performance tuning tools in sybase with example. How to optimize sql code in sybase server.

1 Answers   Polaris,


What are the different types of (all page) locks in sybase?

0 Answers  


How to view the log files in sybase?

0 Answers  


Which version of open client works with which ase in sybase?

0 Answers  


How would you configure burn factor in sybase?

0 Answers  


How would you fix a munged log in sybase ?

0 Answers  


What is the relationship between jdbc and sybase?

0 Answers  


How do I exclude a column in sybase?

0 Answers  


What is a natural key in sybase?

0 Answers  


Categories