Interested to Buy Any Domain ? << Click Here >> for more details...
We create an index to fast the search. How it fast the
query? Do we write any special keyword with query?
- 3 Answers
- 5533 Views
- I also Faced
- E-Mail Answers
Answer Posted / ish
It is depend on which type of indexing u r using .
clustered or non clustered.
if u r searching one record then used nonclustered indexing.
if u r searching bulk of record then used clustered indexing
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Which tcl commands are available on the sql server?
Is the primary key column of a table an index in ms sql server?
explain the storage models of olap? : Sql server database administration
How to create dbo table in sql server?
What happens when converting big values to integers?
Write a program using SQL queries to find a unique entry in a table.
What is de-normalization and what are some of the examples of it?
Can we join two tables without primary key?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Where can you add custom error messages to sql server?
Can two different columns be merged into single column? Show practically?
What is temporary stored procedure?
What is triggers and its types?
After removing a table from database, what other related objects have to be dropped explicitly?
How do you Implement SSIS Packages in your Project?
