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

Is db2 a database?

911


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

1082


What's The Percentage Free Space ?

1157


What is a Foreign Key?

1036


What is role in db2?

1040


What is the role of data manager in the db2 database?

1051


What are db2 tables?

1050


can we view the access paths created by dbrm ? how ? thx

6973


What is buffer pool in the db2 database?

1046


How do I copy a table in db2?

951


Mention some fields that are a part of sqlca.

970


Who uses db2?

981


What are the two types of logging in the db2 database? Explain them.

1017


Explain correlated sub-queries.

976


Which is faster delete or truncate?

1069