What is the difference between seek predicate and predicate?
- 1 Answers
- 1139 Views
- I also Faced
- E-Mail Answers
Answer Posted / Trilok.singh
A predicate is a logical expression used to filter or select rows from a database table. A seek predicate, specifically, is a type of predicate used by an index seek operation in MS SQL Server to find data quickly within an index.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to enter binary string literals in ms sql server?
What is the difference between upgrade and migration in sql server?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
List the ways in which dynamic sql can be executed?
What is a view in sql?
Can we shrink data file in sql server?
How to connect php with different port numbers?
How to convert character strings into numeric values?
How raid can influence database performance?
What are wait types?
what is spatial nonclustered index
What are different types of constraints?
What is in place upgrade in sql server?
Why and when do stored procedure recompile?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
