Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 12C with multi-column index     - Three easy open source firewall on the Linux platform (Linux)

- Linux 101 hack book reading notes (Linux)

- Improve WordPress performance (Server)

- Json data with double backslashes to a single backslash Json data processing (Programming)

- Denyhosts prevent hackers using SSH scanning (Linux)

- Quickly build and install Linux KVM system (Linux)

- Docker - for the development and deployment of unified lightweight Linux containers (Linux)

- CentOS 6.6 source compiler GCC upgrade to 4.8.2 (Linux)

- Enterprise Hadoop cluster architecture - DNS installation (Server)

- CentOS 6.5 set under Oracle 12c at startup (Database)

- Hadoop vs spark (Server)

- How open source code libraries hosted on Github (Linux)

- CentOS / Linux SELinux Close (Linux)

- Use regular expressions to check whether the input box to enter a URL (Programming)

- Hibernate4 The Hello World (basic environmental structures) (Programming)

- Nodejs command-line program development tutorial (Programming)

- Jigsaw project will solve the problem of Java JAR hell Mody (Programming)

- The Zabbix2.4.5 source compiler installation under Ubuntu 14.04 (Server)

- Asynchronous communication mechanism between the Android source code analysis thread (Programming)

- Install Oracle JDK 8 and JVM class loading mechanism in Linux (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:      
 
- SUSE Firewall Configuration (Linux)
- Incremental garbage collection mechanism for Ruby 2.2 (Programming)
- Git use and interpretation of common commands (Linux)
- AIX system file security aspects (Linux)
- Java synchronization mechanism: synchronized, wait, notify (Programming)
- How to use Android Studio to play more package names APK (Programming)
- Hutchison DG standby database CPU consumption reached bottleneck repair (Database)
- Linux Network Programming - raw socket instance: MAC header message analysis (Programming)
- Nginx server load balancing dual-system availability (Server)
- Proxmox VE implement KVM OpenVZ virtualization cloud computing (Server)
- Linux System Getting Started Learning: hard disk partition, and to deal with traps (Linux)
- Hibernate + JUnit test entity class generate database table (Programming)
- JavaScript is implemented without new keywords constructor (Programming)
- Java method to read and write files summary (Programming)
- Talking about the shortcomings and deficiencies of the firewall (Linux)
- Ubuntu system process is bound CPU core (Linux)
- Linux crontab (Linux)
- How to upgrade to Ubuntu 14.04 Ubuntu 14.10 (Linux)
- Static member variable modified (Programming)
- Use Visual Studio to compile and use WinGDB remote debugging embedded Linux programs (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.