Oracle Exam 1Z0-909 Topic 9 Question 45 Discussion

Actual exam question for Oracle's 1Z0-909 exam

Question #: 45
Topic #: 9

[All 1Z0-909 Questions]

Examine these statements which execute successfully:

Which two changes will improve this query performance?

ACREATE INDEX 1X7 ON users (user_name) USING HASH;

BCREATE INDEX 1X4 ON Locations (site_id, loc_shared);

CCREATE INDEX IX1 ON locations (loc_shareci) ;

DCREATE INDEX 1X6 ON users (user_name);

ECREATE INDEX 1X3 ON locations <loc_site_id) ;

FCREATE INDEX 1X2 ON locations (loc_mapping) USING HASH; fH

GCREATE INDEX 1X5 ON users (loc_id);

Show Suggested Answer

Suggested Answer: A, D

by Matthew at Aug 23, 2024, 12:51 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-909 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Sherrell

9 months ago

I'm not sure about option E and G, they might not be as effective.

upvoted 0 times

...

Taryn

9 months ago

I believe option A and F could also help in improving performance.

upvoted 0 times

...

Regenia

10 months ago

Option E is clearly a mistake - loc_site_id is not a valid column name. I'm going with B and D as the correct answers.

upvoted 0 times

Desmond

9 months ago

User 2

upvoted 0 times

...

Derrick

9 months ago

User 1

upvoted 0 times

...

Vilma

10 months ago

I agree with Dalene, those indexes seem relevant to the query.

upvoted 0 times

...

Terrilyn

10 months ago

Haha, I bet the exam writer just threw in that silly index name 1X3 on loc_shareci to trip us up. Nice try, but I'm not falling for that one!

upvoted 0 times

...

Dalene

10 months ago

I think option B and D will improve query performance.

upvoted 0 times

...

Dannette

10 months ago

I'm not sure about the HASH index on user_name in option A. Btree is usually better for equality lookups. Option F also looks a bit weird with the typo in the index name.

upvoted 0 times

Robt

9 months ago

We should probably go with Btree for user_name index. And yes, option F definitely has a typo that needs to be fixed.

upvoted 0 times

...

Joanne

9 months ago

I agree, Btree is usually better for equality lookups. And yes, option F does look a bit strange with that typo.

upvoted 0 times

...

Glendora

9 months ago

I think you're right about the HASH index on user_name, Btree might be better for that. Option F does have a typo in the index name.

upvoted 0 times

...

Jospeh

10 months ago

Option B and D seem like the best choices to improve performance. Indexing the columns used in the WHERE clause can really boost query speed.

upvoted 0 times

Loreta

9 months ago

Let's go ahead and implement those changes then.

upvoted 0 times

...

Almeta

9 months ago

Agreed, those indexes will definitely improve query performance.

upvoted 0 times

...

Verona

9 months ago

Creating indexes on the columns used in the WHERE clause is key.

upvoted 0 times

...

Nichelle

10 months ago

I think option B and D are the way to go.

upvoted 0 times

...