1. SQL technique: views and indexes. A view is simply any SELECT query that has been given a name and saved in the database. For this reason, a view is sometimes called ...

  2. A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to ...

  3. This chapter discusses what database objects are, how they act, how they are stored, and how they relate to one another.

  4. Introduction to Schema Objects. A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name ...

  5. See Also: Oracle Database Concepts for conceptual information about indexes and indexing, including descriptions of the various indexing schemes offered by Oracle

  6. I am running a DTS to preform tasks in my database, in which at first I need to disable all indexes in the database and re-enable them when the DTS finish his work.

  7. Can someone please explain to me in simple English how an index on a view works? I have a fairly simple understanding of indexes on tables; how would indexing a view ...

  8. How to create index. How to create unique index. How to use sql index.

  9. Sometimes as a DBA we need to generate a T-SQL script for dropping and creating indexes in our SQL Server databases. However, …

  10. With SQL Server 2000, you can create indexes on views, a function that promises to make query-writing easier while making your applications and queries run faster.