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

how can you access index

Answer Posted / pandu

first of all create index
create index<indexname> on <tablename>(<columnname>);
after that we have to access to that by
Select * from <indexname>


Correct me is am i wrong...
Thank You.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a dbrm in db2?

1009


What action db2 takes when a program aborts in the middle of a transaction?

1132


What are the rules for db2 programming?

1071


What are the contents of dclgen?

1089


How will you return the number of records in table?

917


Explain the contention situations caused by locks?

1052


How can you do the explain of a dynamic sql statement?

1056


How to view db2 table structure?

1002


What is db2 optimizer?

1217


Outputs of explain are with matchcols = 0. What does this signify?

1041


What are concurrency issues?

1074


What is schema in db2?

1007


What is cloudant database?

1077


What is plan in cobol db2?

1113


How to find the maximum value in a column in the db2 database?

1061