Re: Unix or Win/NT

1)
Main reason to prefer Unix would be scalability. NT supports 4 processors max and 512 Mb of memory. Also (though I haven't seen any benchmarks) I would assume Unix has less overhead, while NT is inherently a windowed system (OK, I have seen you can undo this advantage by running X-windows client on a system that is also a database server) Main reason to prefer NT: Unix definitely won't run without a system administrator and don't think someone with a PC background is capable of administering Unix. If your entire environment is PC-bound and you don't need the scalability, choose for NT

2)
and Oracle 7 is, and Oracle 6 was, and Oracle 5 etc.

In a previous job we resorted to a tric to resolve this. We badly needed a sort key (some 30000 product descriptions). We added a redundant denormalized column with the first 12 characters of the original column capitalized. This column was indexed. Worked well.

Hth,

Sybrand Bakker, Oracle DBA

Vanhelmont wrote:

> Hello,
>
> I have two questions:
>
> 1) What's the reasons to prefer a UNIX machine rather than a Windows NT
> server or a Windows NT server rather than a UNIX machine to install an
> Oracle8 Database ?
>
> 2) Oracle8 is case sensitive!
>
> select ename from emp_table
> where upper(ename) like 'A%'; this make it unsensitive,
> is there an other option?
>
> Thank You!!
>
> Vanhelmont Eddy
> evanhelmont_at_yahoo.com
> Belgium.

Received on Mon Jan 04 1999 - 13:25:54 CST