Comparison of different SQL implementations

Comparison of different SQL implementations
What are the limitations of MSDE?
Compare SQL Server 2008 Edition Features
Oracle Database 10g Express Edition
Limitations of Oracle Database 10g Express Edition

MS SQL is using filegroups. Tablespace is used by MySQL, PostgreSQL and Oracle.

Index hints
SQL SERVER – Force Index Scan on Table – Use No Index to Retrieve the Data – Query Hint
SELECT ProductID, ProductNumber, Color
FROM Production.Product WITH (INDEX(0))
WHERE ProductID < 500

Force T-SQL Query to Use Certain Index to Improve Query Performance

Oracle force index tips
The
easiest way to force index usage is with the index hint.  When
forcing an index, always use the table alias whenever you have a query

that specifies an alias. For example, the following query will force
the
use of the dept_idx index because the emp table is aliased with “e”:

select /*+
index(e,dept_idx) */ * from
emp e;

Advertisements
This entry was posted in Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s