SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Which index should be created where
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sgondesi
Posting Yak Master

India
194 Posts

Posted - 10/30/2013 :  13:57:39  Show Profile  Reply with Quote
why is it recommended that,

Clustered indexes should be created on tables which are frequently modified. &
Non-Clustered indexes should be created on tables which are frequently queried.

someone please explain me why.

--
Thanks and Regards
Srikar Reddy Gondesi,
Trainee SQL Server Database Administrator
Miracle Software systems, Inc.

Edited by - sgondesi on 10/31/2013 03:34:25

James K
Flowing Fount of Yak Knowledge

3744 Posts

Posted - 10/30/2013 :  14:09:23  Show Profile  Reply with Quote
quote:
Originally posted by sgondesi

why is it recommended that,

Clustered indexes should be created on tables which are frequently modified. &
Non-Clustered indexes should be created on tables which are frequently queried.

someone please explain me why.

--
Thanks and Regards
Srikar Reddy Gondesi,
Trainee SQL Server Database Administrator
Miracle Software systems, Inc.

Where does it say that?

As in everything, there are no hard and fast rules in SQL, so those statements are not necessarily gospel.
Go to Top of Page

sgondesi
Posting Yak Master

India
194 Posts

Posted - 10/31/2013 :  03:27:02  Show Profile  Reply with Quote
quote:
Originally posted by James K

quote:
Originally posted by sgondesi

why is it recommended that,

Clustered indexes should be created on tables which are frequently modified. &
Non-Clustered indexes should be created on tables which are frequently queried.

someone please explain me why.

--
Thanks and Regards
Srikar Reddy Gondesi,
Trainee SQL Server Database Administrator
Miracle Software systems, Inc.

Where does it say that?

As in everything, there are no hard and fast rules in SQL, so those statements are not necessarily gospel.



I read that in a website.
actually i lost all my tabs opened in my google chrome due to some problem.so i cannot send you that site address.

ok let me ask in other way.

Non clustered Index with clustered index is effective or non clustered index with heap is effective?

--
Thanks and Regards
Srikar Reddy Gondesi,
Trainee SQL Server Database Administrator
Miracle Software systems, Inc.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000