Welcome Guest. Sign in or Signup

1 Answers

Building an Index

Asked by: 2447 views SQL

Building an Index would make transactions on a table faster. How would you choose the fields on which the Index needs to be built?

Related Questions

1 Answers

  1. jagan1609 on Jun 03, 2014 Reply

    Adding a Custom Index
    To add an index:
    1. Open the record.
    2. Select Tools, Data Administration, Indexes to access the Change Record Indexes dialog box.
    3. Click Add Index.
    4. Move the field under the new index row:
    In the Record Fields list box, select the field that you want indexed.
    Click the arrow button, or double-click the field.
    Repeat this step for each field that you want to add.
    5. Click OK.
    6. Save the record definition.
    7. Select Build, Current Project.
    8. Select Create Indexes under Build Options.

    0 Votes Thumb up 0 Votes Thumb down 0 Votes

Answer Question