Z-Archive » Maybank Projects » M2U UPASS Project

Rem =====================================================================

Rem   NAME

Rem     <tb_index.sql>

Rem   DESCRIPTION

Rem     <Index Creation for faster retrieval> 

Rem   MODULE

Rem     <Authentication Module>

Rem   MODIFIED  (MM/DD/YYYY)

Rem        YCLiew           12/10/2008 - Creation

Rem        xxxxxx           mm/dd/yyyy - Modify

Rem =====================================================================

SET FEEDBACK 1

SET NUMWIDTH 10

SET LINESIZE 80

SET TRIMSPOOL ON

SET TAB OFF

SET PAGESIZE 100

SET ECHO OFF 

Rem CREATE INDEX ix_user_user_type

Rem       ON tb_am_user (u_user_type);

COMMIT;