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 the use of runstats in db2?

1048


What are the various data types available in db2?

1029


How to connect to db2 database from windows command line?

1018


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

1008


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

1111


What is isolation level in db2?

957


What is db2 purescale?

953


What is a buffer in memory?

1021


what are bind concepts in db2 cobol?

1045


Which is faster delete or truncate?

1081


Explain the function of data manager.

1002


List down the types of triggers in the db2 database?

976


If I have a view which is a join of two or more tables, can this view be updateable?

1096


What is the purpose of using commit?

1052


How to access db2 tables in mainframe?

1011