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

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

0 Answers  


How would you configure identities in sybase?

0 Answers  


Compare join and subquery in performance?

0 Answers  


Why place tempdb and log on low numbered devices?

0 Answers  


How to check sybase database status in linux?

0 Answers  


What do you mean by sybase iq?

0 Answers  


What is the use of 'with check' option in views?

0 Answers  


You need to manipulate varbinary columns in sybase. How would you do that?

0 Answers  


Is sybase open source?

0 Answers  


can i gat any proper material for sybase if possible plz let me know balaji.cc1@gmail.com

2 Answers  


Differentiate between db-lib and ct-lib?

0 Answers  


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

1 Answers   Polaris,


Categories