Answer Posted / neha_gupta
The index for a table is selected , if there is a column
which is getting repetedly called in your queries.
On the data of the table the type of index can be selected.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How do I manually create a database?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Which database is best to store images?
Can you create a database in word?
Can we use redis as database?
What is a database string?
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
What is the DIF format and when we will use in teradata
Explain database partitioning.
can u combine pipeline parallelism and partition parallalism? how and whan?
How does non-cluster index functions?
what is transaction state, buffer management, shadow paging
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
Explain normalization in one line?
How heap is implemented in database?