FilesExpand file tree

 master

/

example_create_index.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

75 lines (66 loc) · 2.11 KB

 master

/

example_create_index.sql

Copy path

Top

File metadata and controls

• Code
• Blame

75 lines (66 loc) · 2.11 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

-- +----------------------------------------------------------------------------+

-- | Jeffrey M. Hunter |

-- | jhunter@idevelopment.info |

-- | www.idevelopment.info |

-- |----------------------------------------------------------------------------|

-- | Copyright (c) 1998-2015 Jeffrey M. Hunter. All rights reserved. |

-- |----------------------------------------------------------------------------|

-- | DATABASE : Oracle |

-- | FILE : example_create_index.sql |

-- | CLASS : Examples |

-- | PURPOSE : Example SQL script to demonstrate how to create indexes with |

-- | proper naming conventions. |

-- | NOTE : As with any code, ensure to test this script in a development |

-- | environment before attempting to run it in production. |

-- +----------------------------------------------------------------------------+

/*

* -------------------------------

* UNIQUE INDEX

* -------------------------------

*/

CREATE UNIQUE INDEX emp_u1

ON emp(emp_id)

TABLESPACE indexes

STORAGE (

INITIAL 256K

NEXT 256K

MINEXTENTS 1

MAXEXTENTS 121

PCTINCREASE 0

FREELISTS 3

)

/

/*

* -------------------------------

* NON-UNIQUE (default) INDEX

* -------------------------------

*/

CREATE INDEX emp_n1

ON emp(name)

TABLESPACE indexes

STORAGE (

INITIAL 64K

NEXT 64K

MINEXTENTS 1

MAXEXTENTS 121

PCTINCREASE 0

FREELISTS 3

)

/

/*

* -------------------------------

* PRIMARY KEY INDEX

* -------------------------------

*/

ALTER TABLE emp

ADD CONSTRAINT emp_pk PRIMARY KEY(emp_id)

USING INDEX

TABLESPACE indexes

STORAGE (

INITIAL 64K

NEXT 64K

MINEXTENTS 1

MAXEXTENTS 121

PCTINCREASE 0

)

/