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

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

0 Answers  


How do I connect to a sybase database?

0 Answers  


What is replication server? What is its role in sybase?

0 Answers  


What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

0 Answers  


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

1 Answers   Polaris,


What is open client in sybase?

0 Answers  


Explain the advantages of sybase iq.

0 Answers  


What is a natural key in sybase?

0 Answers  


You need to multiply all values of a single column. How would you do that?

0 Answers  


What is replication server?

0 Answers  


What is replication server in sybase?

0 Answers  


What are Magic Tables?

4 Answers   TCS,


Categories