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

Explain the structure of adaptive server enterprise?

0 Answers  


How to clear tempdb when the tempdb gets filled in sybase?

0 Answers  


Explain intimate shared memory(ism)

0 Answers  


List similarities and differences between oracle & sybase.

0 Answers  


What is my identity burn factor vulnerability right now in sybase?

0 Answers  


Which should I use, repagent or ltm in sybase?

0 Answers  


What is procedure cache and data cache in sybase?

0 Answers  


How do I move tempdb off of the master device?

0 Answers  


How do I configure the burn factor in sybase?

0 Answers  


Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

0 Answers  


How do you check database space? What measures are there to increase the db space?

0 Answers  


What is open server in sybase?

0 Answers  


Categories