Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 12C with multi-column index     - DM9000 bare Driver Design (Programming)

- The security configuration of Linux (Linux)

- Java 8 Lambda principle analysis (Programming)

- How screenshots from the Linux command line (Linux)

- Binder began to talk about inter-process communication mechanism from Android AIDL (Programming)

- How to create a new file system / partitions under Linux terminal (Linux)

- Linux / Windows setup is complete port range (Linux)

- Search Linux commands and files - which, whereis, locate, find (Linux)

- Understanding Linux firewall Iptables (Linux)

- Disk storage structure and file recovery experiment (FAT file system) (Linux)

- APR for Tomcat installation under Linux (Server)

- Troubleshooting Linux virtual machine device id and the letter of inconsistencies (Linux)

- Apple Mac computer to install Windows 10 Concise Guide (Linux)

- Ubuntu 14.10 How to install office suite Calligra Suite 2.8.7 (Linux)

- Java memory mechanism Description (Programming)

- How to use the TF / SD card making Exynos 4412 u-boot boot disk in Mac (Linux)

- shell script: the number of characters in the text to print no more than 6 words (Programming)

- Zabbix monitors the status of TCP connections (Server)

- DB2 commonly used scripting sort out (Database)

- Install KVM on Ubuntu and build a virtual environment (Linux)

 
         
  Oracle 12C with multi-column index
     
  Add Date : 2017-04-13      
         
         
         
  In Oracle 12c, Oracle has provided can create different indexes on the same column of a table used for performance tuning SQL, but only one index is visible.

Here is an example
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter session set container = pdb1;

Session altered.

SQL> CREATE TABLE t (
  2 id NUMBER,
  3 ename VARCHAR2 (50)
  4);


Table created.


SQL> CREATE INDEX t_idx1 ON t (ename) VISIBLE;


Index created.


SQL> CREATE INDEX t_idx2 ON t (ename) INVISIBLE;
CREATE INDEX t_idx2 ON t (ename) INVISIBLE
                        *
ERROR at line 1:
ORA-01408: such column list already indexed

 


SQL> CREATE BITMAP INDEX t_idx3 ON t (ename) INVISIBLE;


Index created.
SQL> l
  1 SELECT a.index_name,
  2 a.index_type,
  3 a.partitioned,
  4 b.partitioning_type,
  5 b.locality,
  6 a.visibility
  7 FROM user_indexes a
  8 LEFT OUTER JOIN user_part_indexes b ON a.index_name = b.index_name where a.table_name = 'T'
  9 * ORDER BY index_name
SQL> /


INDEX_NAME INDEX_TYPE PARTITIONED PARTITIONING_TYPE LOCALITY VISIBILITY
---------- ---------- ------------ ------------------ --------- -------- ----------
T_IDX1 NORMAL NO VISIBLE
T_IDX3 BITMAP NO INVISIBLE
     
         
         
         
  More:      
 
- Mac OS X 10.9 build Nginx + MySQL + php-fpm environment (Server)
- How to use the internal network IP forwarding to connect to the Internet on Linux (Linux)
- Lua regex (string function) (Programming)
- Print Linux system error codes (Linux)
- Using Linux command line and execute PHP code (Programming)
- Applications in Objective-C runtime mechanism (Programming)
- ActiveMQ5.10.2 version configuration JMX (Linux)
- 11G ASM disk group does not automatically handle MOUNT (Database)
- CentOS 7 How to install MySQL Server (Database)
- The security configuration of Linux (Linux)
- Sublime Text 3 practical functions and shortcut keys used to collect (Linux)
- MySQL partition table Comments (Database)
- To assign multiple IP addresses NIC on the CentOS 7 (Linux)
- Golang environment configuration recommendations (Linux)
- Oracle Linux 5.9 configuration Xmanager (Linux)
- Tmux Getting Start (Linux)
- 24 Docker recommendations (Linux)
- Camera-based face recognition OpenCV crawl and storage format (Python) (Linux)
- OpenSSL for secure transmission and use of skills of files between Windows and Linux (Linux)
- Hadoop 2.5 Pseudo distribution installation (Server)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.