Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 12C with multi-column index     - Modify Linux terminal prompt path length (Linux)

- Java 8 perspective annotation types (Programming)

- Proxmox VE implement KVM OpenVZ virtualization cloud computing (Server)

- Linux environment variable settings and save places (Linux)

- How to Install Focuswriter 1.4.5 (Linux)

- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)

- MongoDB 3.0 New Features (Database)

- osprofiler use OpenStack Cinder Lane (Server)

- Ubuntu upgrade to Linux Kernel 4.2.3 Kernel (Linux)

- Using RAID in Linux: Create a RAID 5 (Linux)

- Linux environment variable configuration and save places (Linux)

- Linux Tutorial Share: How to sudo command to define the PATH environment variable (Linux)

- TOAD connect DB2 error SQL1460N solve (Database)

- Using Oracle for Oracle GoldenGate to achieve a one-way data synchronization (Database)

- Linux kernel likely and unlikely to resolve macro definitions (Linux)

- Analysis of C ++ exception mechanism (Programming)

- Linux Command Tutorial: cat command to view the contents of the file (Linux)

- xCAT install and update software (Linux)

- Upgrade installation manual CentOS6.5 GCC4.8.2 (Linux)

- phpinfo (): like phpinfo as a Python script (Programming)

 
         
  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:      
 
- SpringMVC garbage processing (Programming)
- Laravel 4.2 Laravel5 comprehensive upgrade Raiders (Server)
- Kafka cluster deployment (Server)
- C ++ function object (Programming)
- How to build Memcached Docker container (Server)
- The default permissions for files and directories under Linux computing (Linux)
- Using Libreoffice under ubuntu (Linux)
- Learning OpenCV: (VS2010-openCV2.4.3-win7 configuration instructions) (Linux)
- Android imitation UC browser scroll up and down functions (Programming)
- CentOS7 install and configure Nagios (Server)
- The method of CentOS-7.0. The installation and configuration of Tomcat-7 (Server)
- Linux system boot process detail (Linux)
- Oracle 12C truncate table cascade (Database)
- Kernel compile under Debian (Linux)
- Docker use Dockerfile created since the launch of the service support SSH container mirror (Server)
- Linux System Getting Started Tutorial: Linux file permissions brief description (Linux)
- JavaScript cross-browser event object library (Programming)
- PXE + Kickstart automatically install CentOS 6.5 (Linux)
- Ruby and Python simple comparison (Programming)
- Redis 3.0.3 Cluster Setup (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.