Question: What are optimizer hints and how are they used
What are optimizer hints and how are they used?
Answer to relevant QuestionsWhat are some general guidelines for creating and using indexes?Should you create an index on EMP_DOB? Why or why not?What type of database I/O operations will likely be used by the query?Discuss the possible data request scenarios in a distributed database environment, single request accessing a single remote database.Figure D12.1 Single Request to Single RemoteDBMSMultiple requests accessing a single remote database, figure Multiple Requests to a Single RemoteDBMS
Post your question