We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?
- 3 Answers
- 5094 Views
- I also Faced
- E-Mail Answers
Answer Posted / laxman
we need to use indexed column in where clause
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is 4nf in normalization form?
Can we use where and having clause together?
What is tempdb database? : SQL Server Architecture
What is the distinction amongst delete and truncate?
What are truncate options available in sql server? : sql server database administration
What is a livelock?
Mention what are the core components of ssrs?
How column data types are determined in a view?
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 inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
Can we use max in where clause?
What are the differences between user defined functions and stored procedures?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is serializable?
How to convert numeric expression data types using the cast() function?
