How to find tables without indexes?

          

Interview questions

How to find tables without indexes?

Next>>         SQL Server tutorial  

SQL Server - How to find tables without Indexes? - Feb 27, 2010 at 11:50 AM by Shuchi Gauri

How to find tables without Indexes?

USE <database_name>
GO
SELECT SCHEMA_NAME(schema_id) AS schema_name,name AS table_name FROM sys.tables
WHERE OBJECTPROPERTY(OBJECT_ID,'IsIndexed') = 0
ORDER BY schema_name, table_name;
GO

SQL Server - How to find tables without Indexes? - May 05, 2009 at 22:00 PM by Rajmeet Ghai

How to find tables without Indexes?

Tables without indexes can be found using the OBJECTPROPERTY method. The object id is passed and the table is checked for the condition ‘isIndexed= 0’

USE <database_name>;

GO
SELECT SCHEMA_NAME(schema_id) AS schema_name, name AS table_name FROM sys.tables WHERE OBJECTPROPERTY(object_id,'IsIndexed') = 0 ORDER BY schema_name, table_name;
GO

SQL Server - How to find tables without Indexes? - June 21, 2009 at 09:00 AM by Amit Satpute

select t.name from sys.tables t where (t.name not in ( select t.name from sys.tables t join sys.indexes i on (t.object_id = i.object_id) where (t.type = 'U') and (i.type = '1') ) )


Next>>

Also read

What is index? Define its types.

Answer - Index can be thought as index of the book that is used for fast retrieval of information. Index uses one or more column index keys and pointers to the record to locate record.........

Indexing XML data in SQL Server 2005

Explain the concepts of indexing XML data in SQL Server 2005.
Provide basic syntax for creating index on XML data type column.
What is content indexing/full text indexing?
Explain the reason to index XML data type column.
What are the guidelines to be adhered when creating a XML index?..........

Sql Server database maintenance

Explain the concepts of faster differential backups.
Explain the concepts of Parallel Database consistency check (DBCC)
Define Indexed view.
Define Distributed partitioned views.
Define Full-text indexing.
Define Log shipping.............

Describe the XML support SQL server extends.

Answer - SQL server can return XML document using FOR XML clause......

Explain in brief how SQL server enhances scalability of the database system.

Answer - SQL Server has efficient ways to enhance scalability of the database system......



Write your comment - Share Knowledge and Experience


 

 
Latest placement tests
Latest links
 
Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring