Interested to Buy Any Domain ? << Click Here >> for more details...
WHAT IS INDEXING?
- 3 Answers
- 7046 Views
- Patni, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / savithri
A database index is a data structure that improves the
speed of operations in a table. Indices can be created
using one or more columns, providing the basis for both
rapid random lookups and efficient ordering of access to
records.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sunny sarin
Indexing is creating an index for a table in the database to
fasten the speed of retrieving the results and for better
performance and efficiency.
Normally,indexes are of 2 types
unique
non-unique
unique index is created implicitly by the server whenever
any primary or foreign key constraint is given to any
column/s in the table.
we can also create a non unique index for any column in the
table.
indexes are stored on a different segment than the
table,this reduces contention on the table
indexes should not be created for that columns for which the
value in the column varies a lot.
indexes should also not be created on the columns on which
high level of DML's and DDL's are performed.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pppandu
It Is One Of The Database Object,Which Automatically
Created While Creating The Primary Keys Those Gives More
Performance
| Is This Answer Correct ? | 1 Yes | 4 No |
Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz
What is the definition of database management system?
write a query to retrieve the last day of next month in oracle.
What are the different types of database?
What is rdbms table?
What is data abstraction in dbms?
What is package in dbms?
Describe why operational and informational systems are separate.
Which free database is best?
What are the three levels of data abstraction?
Segregate database technology's development.
What do you mean by denormalization?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
