Under which circumstance should you create an index on a table?A. The table is small.B. The table is updated frequently.C. A columns values are static and contain a narrow range of valuesD. Two columns are consistently used in the WHERE clause join condition of SELECTstatements.

D

  • Interview Candidate
  • 4
  • 5367

Showing Answers 1 - 4 of 4 Answers

Avdhesh Kumar

  • Sep 27th, 2007
 

We create a index on table when we have thoushand of row in table and user want to search the record on some conditions. so create a index according to your where clauses.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions