> ## Documentation Index
> Fetch the complete documentation index at: https://docs.peaka.com/llms.txt
> Use this file to discover all available pages before exploring further.

# EXECUTE

## Synopsis

```sql theme={null}
EXECUTE statement_name [ USING parameter1 [ , parameter2, ... ] ]
```

## Description

Executes a prepared statement with the name `statement_name`. Parameter values
are defined in the `USING` clause.

## Examples

Prepare and execute a query with no parameters:

```sql theme={null}
PREPARE my_select1 FROM
SELECT name FROM nation;
```

```sql theme={null}
EXECUTE my_select1;
```

Prepare and execute a query with two parameters:

```sql theme={null}
PREPARE my_select2 FROM
SELECT name FROM nation WHERE regionkey = ? and nationkey < ?;
```

```sql theme={null}
EXECUTE my_select2 USING 1, 3;
```

This is equivalent to:

```sql theme={null}
SELECT name FROM nation WHERE regionkey = 1 AND nationkey < 3;
```

## See also

[PREPARE](/sql/reference/prepare)