search results

  1. Views are also known as virtual tables because the result set returned by the view has the same general form as a table with columns and rows, and views can be ...
    msdn.microsoft.com/en-us/library/​aa933148(v=SQL.80) - Cached
    More results from msdn.microsoft.com »
  2. Spatial types are supported only for MyISAM tables and indexed columns must be ... The noncompact format used in older versions of MySQL can still be ...
    dev.mysql.com/doc/refman/5.0/en/create-​table.html - Cached
  3. In MySQL 3.22 or later, the table name can be specified as db_name.tbl_name to ... Spatial types are supported only for MyISAM tables and indexed columns must be ...
    dev.mysql.com/doc/refman/4.1/en/create-​table.html - Cached

  4. Database index - Wikipedia, the free encyclopedia

    The data rows may be spread throughout the table regardless of the value of the indexed ... table. Clustered indices can ... table scan. Consider this SQL ...
    en.wikipedia.org/wiki/Index_(database) - Cached
    More results from en.wikipedia.org »
  5. ... can come from one to many different base tables or even other views. This T-SQL select command ... can programmatically determine if a view can be indexed or ...
    www.sqlteam.com/article/indexed-views-​in-sql-server-2000
  6. You don\'t even have to drop the index in the table, you can defer the index processing in the insert statement without changing the table. From the mysql manual: When ...
    lists.mysql.com/mysql/9043 - Cached
  7. Indexed Views can really provide enormous preformance benefits under the right circumstances and the right use. ... joined tables. With SQL Server 2000, ...
    www.madeira.co.il/sql-server-indexed-​view-2 - Cached
  8. Queries that don’t specifically use the indexed view can even benefit ... utilizing the base tables instead, you can specify ... with SQL Server 2008 Indexed ...
    www.databasejournal.com/.../SQL-Server-​Indexed-Views.htm - Cached
  9. Hi, I have some 100 GB of data and its growing at a faster pace. We would like to use Mysql Cluster 7 to have scalability and to be cost-effective.
    forums.mysql.com/​read.php?25,265280,265280 - Cached
  10. While all editions of SQL Server can create and consume an indexed ... disk as the base tables are modified. Both of these costs can be substantial and limit ...
    www.databasejournal.com/features/mssql/​article.php/2119721 - Cached