How to create Index

[Former Member]

Hi

     I have 1 UDT table with No Object . I want to create index on fields say ID,month. How it can be done

Thanks

[KennedyT21 · Accepted solution]

Hi Sunny Brar

You can set a user-defined field (or several fields together) as a key in the database table to make the field (or set of fields) unique and prevent duplicates.

In the menu bar, choose Tools → Customization Tools → User-Defined Fields - Management.

Select the table for which you would like to define a key, and choose the Keys button.

The User Tables Keys – Setup window appears.

To create a new key for the table, choose the New button. The system creates a key with the name IX_0.

In the Key Name field, you can change this default name. You can create as many keys as you need by choosing New. You can also browse between the different keys by selecting them from the dropdown list.

In the table, select the user-defined fields you want to include in the selected key. Note

You can define more than one user-defined field in one key.

Select the Unique checkbox.

If the key is made up of one field, values entered for that field must be unique. If the key is made up of more than one field, the set of values for these fields must be unique.

Choose the Update button, and then the OK button.

Hope helpful

Regards

Kennedy

[radu_simen · Accepted solution]

What about search indexes/join optimisation on custom fields ? non-unique values constraint ?

[pvsbprasad]

Hi,

Try this

Tools-> Customization Tools->User defined fields->Select the table name->Click Add ->then Give Tilte and descption

Regards,

Prasad

[kothandaraman_nagarajan]

Hi Sunny Brar,

Please refer below link:

http://www.pioneerb1.com/wp-content/uploads/2012/06/How-to-Create-User-Defined-Fields-and-Tables.pdf

Thanks & Regards,

Nagarajan