can u provide me with download link for Data Dude (free version)

Consider i have two tables University(parent table) and Branch(child table) The primarty key for university table is id ,the foriegn key for the branch table is uid

i have a...

Thanks Wilson,

It's working :).

i have a table called university which have two fields id and name.

i tried this way.

SELECT CASE u.id

WHEN 2 THEN 'GOOD'

...

Thanks for the information.

Thanks,

yes Ian, my lookup table has more than 1000 rows.

By composite index i mean that i can put the two conditions in the where clause lkup_type and lkup_value together as...

currently i'm in a project that deals with more than 130 tables,apart from the indexing primary keys if i start indexing foriegn keys then apart from performance being improved...

Thanks for the info.:) i will check it.

Kiran.

Jeff,

:blink: Can u give me more details regarding when can i use hints in my query.

Kiran.

thanks jeff,

one more thing.I am using Toad to know the explain plan of my queries.The query optimizer is taking nested loop join...