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 choose which tables to partition in sybase?

0 Answers  


Can two tasks be assigned to the same partition in sybase?

0 Answers  


How do I exclude a column in sybase?

0 Answers  


What are the important features of sybase?

0 Answers  


Explain asa, asa ultralite.

0 Answers  


How to view the log files in sybase?

0 Answers  


What is the default size of master database in sybase?

0 Answers  


Explain table partitioning in sybase.

0 Answers  


Are there any alternatives to isql in sybase?

0 Answers  


What is replication in sybase?

0 Answers  


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

0 Answers  


What do you mean by sybase iq?

0 Answers  


Categories