Indexes on Table

Question

I have some indexes created one of my sql select statement is using index (because in execution plan it is seeks instead of scan). I want to know which index is being used by this select statement. Thanks and Regards Nayeem

Nayeem Mohammed · Answer

These are the column in my Table : ItemID Title TitleAlias RelatedImage SectionName ShortDescription WAPTitle WAPDescription Tags Content Sticky Specials Byline ShowArticleInFront ShowArticleInFrontSection AlternativeTitle VideoSource VideoURL PageUrl TemplateReference ContentType oldnid OldNodeType ItemCreatedBy ItemCreatedWhen ItemModifiedBy ItemModifiedWhen ItemOrder ItemGUID NodeAliasPath ImageURL MetaKeywords BlogLink AddImage PageTemplateId Status IsPublished PublishedTo PublishedFrom DocumentID DocumentGUID BrighcoveReferenceID RelatedArticlesID TopImage TargetURL IsRestored SectionURL ReleaseDate RelatedCandidates MainTopic IsTextOrVideo

Bhuvanesh Mohankumar · Answer

Can you give the column structure of the table that will be helpful to answer you exactly.