02-18-2013 08:31 AM
I want to know, if someone has added the database schema into the SLX web queries, like:
select * from sysdba.contact;
--sysdba is the schema
I know that the groups are saved into the PLUGIN table but if I want to check the query used to load a group, in the DATA field, it is unreadable..., then I cannot add the "sysdba" prefix into the query.
Can someone help me please?
Thank you so much,
02-18-2013 11:31 AM
02-18-2013 11:59 AM
Thank you RJLedger for answering my post.
Actually we have detected that adding the prefix (schema name) in each join helps to execute the queries quicker..., we have done this on our customized website, but now we can do the same thing on SLX web.
Is there anyway to do this?
Thank you & best regards,
02-18-2013 02:19 PM
Not really without a TON of hacking.. and then I'm not sure you could get it all. Not really worth the effort.
What really needs to be done is to deal w/DB "tuning" in general.