Home » SQL & PL/SQL » SQL & PL/SQL » Binary Index and Btree Index
Binary Index and Btree Index [message #205671] Mon, 27 November 2006 00:59 Go to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Can we create a Binary Index and Btree Index on a same column.

Plz explain the concept.

thnx


Re: Binary Index and Btree Index [message #205696 is a reply to message #205671] Mon, 27 November 2006 03:10 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I presume by Binary Index, you mean a Bitmap Index.

Yes - you can have both types of index on the same column, but given the differences in the two index types, one of them will be all but useless.
Re: Binary Index and Btree Index [message #205701 is a reply to message #205696] Mon, 27 November 2006 03:19 Go to previous messageGo to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
Thnx, But which one u think will be generally Oracle Optimizer use..?
Re: Binary Index and Btree Index [message #205702 is a reply to message #205701] Mon, 27 November 2006 03:21 Go to previous messageGo to next message
atulrsingh
Messages: 55
Registered: November 2006
Location: Mumbai
Member
atulrsingh wrote on Mon, 27 November 2006 14:49
Thnx, But which one u think will be generally Oracle Optimizer use..?


plz can u give a small explaination on the Btree Index..
Re: Binary Index and Btree Index [message #205716 is a reply to message #205702] Mon, 27 November 2006 04:10 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14220/schema.htm#sthref893
Previous Topic: How to make package for this?
Next Topic: DBMS_SQL
Goto Forum:
  


Current Time: Fri Dec 02 12:15:31 CST 2016

Total time taken to generate the page: 0.05149 seconds