What is an index and types of indexes. How many number of
indexes can be used per table ?
Answer Posted / swapna vamsi
Indexs are used for the faster retrivel of data.
two types of indexes
Cluster index,unclustered index
we can have one cluster index and uotp 249 cluster indexes
for a table
| Is This Answer Correct ? | 63 Yes | 38 No |
Post New Answer View All Answers
Cite the differences between execution of triggers and stored procedures?
What is cte sql?
What is db journal file?
What is the difference between syntax error and runtime error?
What is the best partition size for windows 10?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
What is the difference between cross join and natural join?
How do you write a subquery?
What is update query?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What is record type in pl sql?
Explain the savepoint statement.
define join and explain different type of joins? : Sql dba
Enlist the data types that can be used in pl/sql?
What steps server process has to take to execute an update statement?