What is the difference between SQL Server and Oracle?
Even though both Oracle and SQL Server are RDBMS they have some key differences. Oracle runs in range of platforms, while SQL Server runs only on Windows. Furthermore, Oracle claims that it has more robust administration utilities than SQL Server. For large tables and indexes, SQL Server does not provide range partitioning, while Oracle allows to partition large tables at the database level in to range partitions. SQL server does not provide star query optimization, reverse key indexes and indexes based on functions. But, Oracle will cost about three times as SQL Server.