What is difference between SOQL and SOSL?
SOQL
|
SOSL
|
SOQL (Salesforce Object Query Language ) retrieves the records from the database by using “SELECT” keyword.
|
SOSL(Salesforce Object Search Language) retrieves the records from the database by using the “FIND” keyword.
|
By Using SOQL we can know in Which objects or fields the data resides.
|
By using SOSL, we don’t know in which object or field the data resides.
|
We can retrieve data from single object or from multiple objects that are related to each other.
|
We can retrieve multiple objects and field values efficiently when the objects may or may not be related to each other.
|
We can Query on only one table.
|
We can query on multiple tables.
|
