m2u-upass-admin / DBScript / tb_index.sql @ 63:9431991ebe9b
History | View | Annotate | Download (605 Bytes)
1 |
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;
|