what are indexes..how many types of index's are there and
what are they?
Answer Posted / guest
when queries are run against a DB,an index on that DB
basically helps in the way the data is sorted to process
the query for faster data retievals.
There are basically two types of indexes that we use in SQL
Server. Clustered and the Non-Clustered.
| Is This Answer Correct ? | 6 Yes | 6 No |
Post New Answer View All Answers
Name the various constraints used in oracle?
Explain mutating triggers.
Can we store pictures in the database and if so, how it can be done?
How do you find current date and time in oracle?
Please explain oracle left join with an example?
What are the uses of linked server and explain it in detail?
Explain cascading triggers.
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Explain the use of record option in exp command.
How to create a stored function in oracle?
What are the different windows events activated at runtime ?
How to write a query with an inner join in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What is an Oracle index?
How to create an initialization parameter file?