Interested to Buy Any Domain ? << Click Here >> for more details...
What is an index and types of indexes. How many number of
indexes can be used per table ?
- 12 Answers
- 83358 Views
- Accenture, BirlaSoft, Cognizant, CTS, Symphony, I also Faced
- E-Mail Answers
Answer Posted / diptabhaskar ray
the ordering of a table in a database is called index.it
helps in fast access to the specific information.the column
suitable for index should be a primary key or a foreign
key,should be sorted,joins should be allowed and users will
search for data.clustered index and non clustered index.
| Is This Answer Correct ? | 20 Yes | 17 No |
Post New Answer View All Answers
What is the least restrictive isolation level? : Transact sql
What is the difference between clustered and non-clustered index in sql?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
Show the cursor attributes of pl/sql.
Why do we need view in sql?
What is sp_helptext?
What jobs use sql?
Which language is used in sql?
How does a trigger work?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
What are different joins used in sql?
What is the advantage of index in sql?
What is dynamic query?
how to get a list of indexes of an existing table? : Sql dba
Can you sum a count in sql?
