m2u-upass-admin / DBScript / tb_index.sql @ 87:2d3c55260785
History | View | Annotate | Download (605 Bytes)
1 | 0:ea666cc7880e | hadi | Rem ===================================================================== |
---|---|---|---|
2 | Rem NAME |
||
3 | Rem <tb_index.sql> |
||
4 | Rem DESCRIPTION |
||
5 | Rem <Index Creation for faster retrieval> |
||
6 | Rem MODULE |
||
7 | Rem <Authentication Module> |
||
8 | Rem MODIFIED (MM/DD/YYYY) |
||
9 | Rem YCLiew 12/10/2008 - Creation |
||
10 | Rem xxxxxx mm/dd/yyyy - Modify |
||
11 | Rem ===================================================================== |
||
12 | |||
13 | SET FEEDBACK 1 |
||
14 | SET NUMWIDTH 10 |
||
15 | SET LINESIZE 80 |
||
16 | SET TRIMSPOOL ON |
||
17 | SET TAB OFF
|
||
18 | SET PAGESIZE 100 |
||
19 | SET ECHO OFF
|
||
20 | |||
21 | Rem CREATE INDEX ix_user_user_type |
||
22 | Rem ON tb_am_user (u_user_type);
|
||
23 | |||
24 | COMMIT; |