Differences

This shows you the differences between two versions of the page.

oracle:function_based_indexes [August 03, 2012 8:47 am]
sqlines
oracle:function_based_indexes [August 03, 2012 9:01 am] (current)
sqlines
Line 209: Line 209:
There are just 2 rows in the table, so we used UNIQUE index to force SQL Server to use it, and demonstrate There are just 2 rows in the table, so we used UNIQUE index to force SQL Server to use it, and demonstrate
that a index on a computed column can be used even if the query still uses a function in WHERE. that a index on a computed column can be used even if the query still uses a function in WHERE.
 +
 +===== Resources =====
 +
 +  * [[/oracle|Oracle to SQL Server Migration Knowledge Base]]
 +  * [[/sql-server|SQL Server for Oracle DBAs and Developers]]
 +
 +**Oracle 11g R2 Database Concepts**
 +
 +  * [[http://docs.oracle.com/cd/E11882_01/server.112/e25789/indexiot.htm#autoId16|Function-Based Indexes]]
 +
 +**Oracle 11g R2 Database Administrator's Guide**
 +
 +  * [[http://docs.oracle.com/cd/E11882_01/server.112/e25494/indexes003.htm#i1006674|Creating a Function-Based Index]]
 +
 +**Microsoft SQL Server 2012 - Books Online**
 +
 +  * [[http://msdn.microsoft.com/en-us/library/ms189292|Indexes on Computed Columns]]
 +  * [[http://msdn.microsoft.com/en-us/library/ms174979|CREATE TABLE Statement]]
 +
 +**Microsoft SQL Server 2008 R2 - Books Online**
 +
 +  * [[http://msdn.microsoft.com/en-us/library/ms191250(v=sql.105).aspx|Computed Columns]]
 +
 +===== SQLines Services =====
 +
 +SQLines offers services to migrate Oracle databases and applications to Microsoft SQL Server. For more information, please [[/contact-us|Contact Us]].
 +
 +~~NOTOC~~
 +~~DISCUSSION~~