Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How to have groupby and where clause using non clustered index?
on 7/20/2012 |
| Views : 921 | Status :
| Replies : 1
Write New Post
Un Answered Posts
One of advantage of non-clustered index is
"create performance of application where v used where clause
and group by clause"
I want to know in non-clustered index how to use group by and where clause
can anyone provide me with example query
Reply with Attachment
Non-Clustered Indexes store the pointers to the rows in the table. This helps in improving the performance of the queries on the table.
Use Non-Clustered Index on following columns in a table:
1. Create non-clustered index on non-key columns that are frequently used in queries.
2. Columns with lots of distinct values, such as a combination of last name and first name, if a clustered index is used for other columns.
From tbl [t]
where t.id = 5 and t.DateTo = '12/31/2006'
and t.DateInserted = '12/01/2006'
, if this helps please
Mark As Answer
Login to post response
How to close the respective modal dialog when switch over to other modal dialog without overlapping
how to save and use variable in jquery
How to add Parameterized Image in RDLC report?
How to Solve this Hosting Issues.
How do i get payment status in redirect page using bitpay?
What is autocomplete in input tag ?
How to pass parameters from html page to constructor of a class in C#
DropDownList Validation not working inside Gridview