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

Please tell me a query to find the Primary key,Foreign
key,primary Index,PPI for the Database?

Answer Posted / yuvaevergreen

Adding to the above,DBC.Indexes can be used to find whether
the index is PPI or join or hash or primary key.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why managing the data is important?

966


Define views in teradata with general syntax.

991


What is smp and mpp platforms?

912


Steps to create a data model?

1074


Give a justifiable reason why Multi-load supports NUSI instead of USI.

1090


What is meant by a Highest Cost Plan?

995


What is the maximum number of dml can be coded in a multiload script?

1064


how do you manage the production space. what are the proactive methods you can take ?

1884


What are the different softwares used with their functions in teradata?

972


what is object level locking ? where do appear this type of locking ?

3452


How many sessions of MAX is PE capable of handling at a particular time?

1038


How many codd's rules are satisfied by teradata database?

1055


What are the steps involved after the disk manager passes the request?

1043


Which is more efficient group by or distinct to find duplicates?

1039


How to view every column and the columns contained in indexes in teradata?

991