Question Regarding from sub tables?

Database

Question Regarding from sub tables?

Can any body know how to see or retrieve data from sub tables?

Regards,
Mahesh
3 REPLIES
N/A

Re: Question Regarding from sub tables?

users cannot retrieve the data from subtables directly,
Optimizer uses this subtables to fetch the data to requesting user.

Re: Question Regarding from sub tables?

Thanks for your reply.
You mean that.. There is no way to retrieve data from sub tables

-Best Regards,
Mahesh

Re: Question Regarding from sub tables?

Yes, sub tables are used by the Optimizer/Hashing algorithm to reach the actual base tables, but a user cannot auery a sub table directly.