Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle 12C with multi-column index     - Simple Calendar C language (Programming)

- systemctl Command Complete Guide (Linux)

- CentOS and RHEL installation under GAMIT10.6 (Linux)

- By way of a binary installation innobackupex (Database)

- Disk Management LVM (Linux)

- Linux character device - a simple character device model (Linux)

- Storm how to ensure that at least once semantics (Programming)

- MongoDB common optimization settings in Linux (Database)

- Five strokes to find out the IP address you want to know (Linux)

- Orionode source Linux Mint installation (Linux)

- Generators and iterators in Python (Programming)

- Number JavaScript type system (Programming)

- About Java 7 module system (Programming)

- Android Action Compendium (Programming)

- Win7 used Eclipse to connect the virtual machine in Ubuntu Hadoop2.4 (Server)

- Write perfect printf (Programming)

- Zabbix configure DataGuard monitoring (Database)

- awk pattern matching (Programming)

- Oracle conditional select statements and looping statements (Database)

- CentOS 6.5 Linux System Customization and Packaging Quick Implementation Script (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:      
 
- Python function arguments * args and ** kwargs usage (Programming)
- Linux Getting Started tutorial: 3D effects and beautify your desktop (Linux)
- 20 Unix / Linux command skills (Linux)
- C language programming entry - macro definitions and enum (Programming)
- Ubuntu arm-none-eabi-gcc compiler treated with STM32F10x (Linux)
- Elasticsearch 2.20 Beginners: aggregation (Server)
- zBackup: A versatile tool to remove duplicate backup (Linux)
- Five strokes to find out the IP address you want to know (Linux)
- Virtual Judge structures under Ubuntu 14.04 (Server)
- ctop: monitor container performance Linux command line artifact (Linux)
- How to fix Not Enough Free Disk Space On / boot on Ubuntu (Linux)
- The default permissions for files and directories under Linux computing (Linux)
- Linux formatted partition error Could not stat / dev / sda No such file or directory Solution (Linux)
- How to install Linux on a MacBook Pro Retina (Linux)
- HBase Application Development Review and Summary of Series (Database)
- Linux NFS FTP use (Server)
- To compiler and install MariaDB-10.0.20 under CentOS 6.6 (Database)
- Ubuntu install Tonido private cloud services (Server)
- Five useful commands to manage file types and system time in linux (Linux)
- MySQL and Oracle time zone settings compare (Database)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.