In clustered and non clustered indexes which one is faster
while executing a query ?
Answer / arunyadav007
Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.
Thanks,
Arun
Is This Answer Correct ? | 13 Yes | 3 No |
What is RAID? What are the different types of RAID configurations?
What is the New in SQL server 2008?
What is rolap and its advantage? : sql server analysis services, ssas
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
Which Model uses the SET concept
What is the bookmark lookup and rid lookup?
What is the purpose of forms?
What are the advantages of using stored procedures?
How to create an inline table-valued function?
How can we solve concurrency problems?
Do you know spatial data types - geometry and geography in sql server 2008?
Hi SQL gurus, i am working for an MNC... My team is having a problem in sql server. when user slects date prompts from jan 1st to april 30, it should display all months data like : jan aa feb bb mar cc but when it comes to april its taking data like : jan aa feb bb mar cc apr dd...and so on means its taking data again from jan to april which we dont want. we want the data only april month as we are getting jan, feb and mar... can any one write the code to relsove the issue please would be greatful if you can send to shiva_sans@yahoo.co.in and also please send your email also ...so that we will be in touch for any kind of queries ... Thanks a lot in Advance !!!