OraFAQ Forum: SQL & PL/SQL » Index on number and varchar (merged)

Home » SQL & PL/SQL » SQL & PL/SQL » Index on number and varchar (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Index on number and varchar (merged) [message #389431]

Mon, 02 March 2009 01:22

steve01
Messages: 1
Registered: March 2009

Junior Member

Hi,
I know creating index on number is always faster than varchar. But can anyone tell me how it is? How B-tree index is organized internally?

Report message to a moderator

Re: Index on number and varchar [message #389433 is a reply to message #389431]

Mon, 02 March 2009 01:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I know creating index on number is always faster than varchar.
Please provide proof of this unproven claim,

Report message to a moderator

Re: Index on number and varchar [message #389434 is a reply to message #389431]

Mon, 02 March 2009 01:26

MarcS
Messages: 312
Registered: March 2007
Location: Antwerp

Senior Member

Urban Legend I'm afraid Sad

But what do you mean?

That creating an index is faster, or, using an index is faster?

I never noticed a difference in performance between an index on a number and an index on a varchar.

What would be faster in case of a compound index?
- index on a ( number , varchar )
or
- index on a ( varchar , number )

Report message to a moderator

Re: Index on number and varchar [message #389435 is a reply to message #389431]

Mon, 02 March 2009 01:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Repeating false claims does not make them true!

Report message to a moderator

Previous Topic:	DBMS_PROFILER
Next Topic:	Exporting Function output return type sys_refcursor(Result set) to Excel sheet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 19 00:50:03 CST 2025