Re: which column type char,varchar2 is better for index?

Note in-line.

• Regards Jonathan Lewis

Note in-line.

> Depends where you want the efficiency - from an Oracle
> viewpoint,
> 0 is stored as 0x1 0x80
> 1 is stored as 0x2 0xC1 0x02
> which is arguably less efficient than the character equivalent.

Thanks.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)