Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Indexes

711094Apr 9 2010 — edited Apr 9 2010
Hi all,

I think about if it does make sense to create an index on a column which only allows 2 different values. Here is my statement:

SELECT DISTINCT netz_nr
FROM adressen
WHERE ebene = nsp

In the column "ebene" of the table "adressen" are only the entries "nsp" or "msp", so does it makes sense with an index???

Thanks in advance! :-)

Colt

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 7 2010
Added on Apr 9 2010
#database, #dba, #index, #oracle, #sql
1 comment
421 views