Home » SQL & PL/SQL » SQL & PL/SQL » Index on number and varchar (merged)
Index on number and varchar (merged) [message #389431] Mon, 02 March 2009 01:22 Go to next message
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?
Re: Index on number and varchar [message #389433 is a reply to message #389431] Mon, 02 March 2009 01:25 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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,
Re: Index on number and varchar [message #389434 is a reply to message #389431] Mon, 02 March 2009 01:26 Go to previous messageGo to next message
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 )

Re: Index on number and varchar [message #389435 is a reply to message #389431] Mon, 02 March 2009 01:29 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Repeating false claims does not make them true!
Previous Topic: DBMS_PROFILER
Next Topic: Exporting Function output return type sys_refcursor(Result set) to Excel sheet
Goto Forum:
  


Current Time: Fri Dec 09 21:43:33 CST 2016

Total time taken to generate the page: 0.07164 seconds