concatenated indexes

Hi all and a happy new year !

A little question : how does Oracle treat different formats in a concatenated index ?

Exemple : table A (x number(2), y char(10))

          create index ind_A on A(x,y) ...

Are conversion functions used ? If yes how ?

Thanks in advance.

-- 


------------------------------------------------------------------------------

   _/_/_/_/    _/_/_/_/   _/_/_/_/   _/_/_/_/                  I use
  _/_/          _/_/       _/_/       _/_/               ORACLE v6.0.36.5.2
 _/_/          _/_/       _/_/       _/_/                       on        
_/_/_/_/ .  _/_/_/_/ .   _/_/ .   _/_/_/_/ .            DEC RISC ULTRIX v4.3


------------------------------------------------------------------------------

Yves NOEL   -   Database Administrator         Mail : Yves.Noel_at_univ-lille1.fr
C.I.T.I. (batiment M4)                             
Universite des Sciences & Technologies de Lille      Phone : (33)  20.43.42.70
59655 Villeneuve d'Ascq Cedex - FRANCE               Fax   : (33)  20.43.66.25 


------------------------------------------------------------------------------