Answer Posted / vasu
An index seek shows that the index is used in the table and
index scan shows that index is not used in table
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
Differentiate between SQL and ORACLE joins and write their syntax.
What are the disadvantages of indexes?
Can a table be created inside a trigger?
What is the difference between a local and a global temporary table?
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
Name 3 ways to get an accurate count of the number of records in a table?
What is the command dbcc checkdb used for?
What is enhanced database mirroring in sql server 2008?
What is difference between stored procedure and user defined function?
What is the sql server 2000 version number?
What are the different methods available under sqlcommand class to access the data?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is it’s similarity with sql server?
What is policy based management (pbm)? : sql server database administration
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration