What is an index and types of indexes. How many number of
indexes can be used per table ?
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 operating systems are supported by oracle sql developer?
Is record in pl sql?
Is and as keyword in pl sql?
What is Histogram?
Which data type is a composite type?
What is a subquery in sql?
What is scalar function in sql?
What is left join in postgresql?
What are sql procedures?
How do I edit a stored procedure?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
what is the functionality of the function htmlentities? : Sql dba
What mean sql?
What is the reports view in oracle sql developer?
how to drop an existing view in mysql? : Sql dba