Answer Posted / rajesh naidu
INDEX IS USED TO IMPROVE THE PERFORMANCE OF THE DATABASE AND
ALSO IT IS USE FULL FOR FASTER FETCHING THE REQUIRED DATA
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a correlated sub-query? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
what are the performance views in an oracle rac environment?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
What is the difference between clustered and non-clustered index? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
What types of replication are supported in sql server? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What are the commands used in dcl? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA