What is a “primary key”?
Read Answers(5) | 5,088 Views |
The question is not correct.
“What structure can you have the database make to speed up table reads ?”
It is not cleare what exectly the term
“structure” means in this case.
Follow the rules of DB tuning we have to:
1] properly use indexes ( different types of indexes)
2] properly locate different DB objects
across different tablespaces, files and so on.
3] create a special space (tablespace) to locate some of the data with special datatype
( for example CLOB, LOB and …)
So the question is not correct and answer cannot be short and sharp.
Read Answer(1) | 2,596 Views |
What is a “join”?
Read Answers(2) | 5,173 Views |
What action do you have to perform before retrieving data from the next result set of a stored procedure?
Read Answer(1) | 5,875 Views |
What is the basic form of a SQL statement to read data out of a table?
Read Answers(5) | 6,162 Views |
What are two methods of retrieving SQL?
Read Answer(1) | 7,021 Views |
What cursor type do you use to retrieve multiple recordsets?
Read Answers(2) | 6,086 Views |