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...


Can you define an Index if the table size less than 10
PAGES?



Can you define an Index if the table size less than 10 PAGES?..

Answer / s

You do not want to define an index on such a small table
because, its an overhead to maintain the index and
tablespace scan will only result in 1 I/O.

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More DB2 Interview Questions

What does db2 blu stand for?

0 Answers  


DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?

2 Answers  


How does coalesce work?

0 Answers  


wht happens if we close cursor with cursor with hold option?

3 Answers   Valtech,


What is the format (internal layout) of ?TIMESTAMP??

1 Answers  


What is an alias?

3 Answers  


what is a trigger and types of triggers

3 Answers   HSBC,


What os does db2 run on?

0 Answers  


What is meant by index cardinality?

2 Answers  


When is the skeleton cursor table created?

1 Answers  


Categories