At 03:30 PM 12/8/2010, Coxen, Dayle wrote:

Any suggestions how to best re-work this code replacing
the BUILD command?


Dayle,

Use CREATE INDEX command to achieve your goal.

Syntax:

-- For a TEXT column

   CREATE INDEX indexname ON tablename (columnname SIZE nnn)

-- For a numeric column

   CREATE INDEX indexname ON tablename (colname)

For more details and examples:

   HELP CREATE

Very Best R:egards,

Razzak.

Reply via email to