50分!怎样为Dbase数据表建立辅助索引?

[hongsushou]

在对数据表进行查找时,要查找多个字段值,需要为数据表建立辅助索引,请帮帮忙!

[wangsw]

???

[pbdesigner]

string ls_indexsyntax
ls_indexsyntax = 'Create index <index_name> on <tablename> (<columnlist>)'
execute immediate :ls_indexsyntax;
完整语法：
CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED]
INDEX index_name ON table (column [,...n])
[WITH
[PAD_INDEX]
[[,] FILLFACTOR = fillfactor]
[[,] IGNORE_DUP_KEY]
[[,] DROP_EXISTING]
[[,] STATISTICS_NORECOMPUTE]
]
[ON filegroup]