Would it be a good idea to create an index on a table that always contain

Advertise your Business Here

Refer this Site

Login | Sign Up


	To Refer this Site to Your Friends Click Here

Categories >> Software >> Databases >> SQL Server

Oracle Interview Questions

SQL Server Interview Questions

MS Access Interview Questions

MySQL Interview Questions

Postgre Interview Questions

Sybase Interview Questions

DB Architecture Interview Questions

DB Administration Interview Questions

DB Development Interview Questions

SQL PLSQL Interview Questions

Databases AllOther Interview Questions

Question

Would it be a good idea to create an index on a table that 
always contains 10 records? Why or why not?

Question Submitted By :: Vanitha.s

I also faced this Question!!

Rank

Answer Posted By

Re: Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

Answer
# 1

Not a good idea.

Indexes are used for improve select query performance. 
indexes will be useful when the data is more and more.

Is This Answer Correct ?

0 Yes

0 No

Laxman

Re: Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

Answer
# 2

No it is not a good idea. Indexes are very expensive to 
maintain. Indexes are created mainly to improve performace. 
If there are only 10 rows in a table, creating index would 
not make any difference in the performace.

Is This Answer Correct ?

0 Yes

0 No

Bharathi

Question	Asked @	Answers
Other SQL Server Interview Questions


What is the difference between windows authentication and sql server authentication	HCL	3
Wht is the difference between stored procedure and trigger	TCS	2
What is a table called, if it does not have neither Cluster nor Non-cluster Index?		1
what is index seek and index scan?		2
How to create logins using windows Authentication mode?		1
What is a job?		3
What is MSDE?		1
how do we find every fifth record in a table		6
About types of indexes in SQL server ?	Cognizent	1
write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?		3
What is BCP? When do we use it?		1
What are statistics, under what circumstances they go out of date, how do you update them?	HCL	2
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?	GE	1
Where do you think the users names and passwords will be stored in sql server?		2
What are the OS services that the SQL Server installation adds?		1
what is normalization? what is denormalization?	Satyam	4
What is the basic difference between clustered and a non-clustered index?		2
Display a roll having miminum marks in two subjects?	Patni	4
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?		1
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh		3

For more SQL Server Interview Questions Click Here


Copyright Policy \| Terms of Service \| Help \| Site Map 1 \| Articles \| Site Map \| Site Map \| Contact Us \|

Copyright © 2007 ALLInterview.com. All Rights Reserved.

ALLInterview.com :: Forum9.com :: KalAajKal.com