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

What is the default table size in sybase?

0 Answers  


What is replication server?

0 Answers  


How do I set a password to be null?

0 Answers  


You need to add a notnull column in a table by using alter command (without using default command). How would you do that?

0 Answers  


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

0 Answers  


Is data insertion is fast in SYBASE IQ if we have more indexes on a table?

3 Answers   FIC,


How do I connect to sybase?

0 Answers  


When are stored procedures compiled in sybase?

0 Answers  


What is cis and how can I use it?

0 Answers  


How do you view log files in sybase?

0 Answers  


How can set the multipal database ?

0 Answers   CitiGroup,


What do you mean by adaptive server enterprise?

0 Answers  


Categories