How do you select an index for a table

Answer Posted / neha_gupta

The index for a table is selected , if there is a column
which is getting repetedly called in your queries.
On the data of the table the type of index can be selected.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain normalization in one line?

634


What is difference between server and database?

565


What is ole db in ssis?

610


Explain entity ?

598


can we delete autodiff back up that we have set through sql server agent.

1737






What is odm in database?

581


Why do we need distributed database?

539


What will happen non-clustered index will be created on clustered index?

608


Explain inner and outer joins with examples.

710


What is global database name?

545


What is a super key?

624


can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

1666


What is table scan and index scan?

612


What are the advantages of normalizing a database.

596


Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:

1808